Mentat Technologies announces the launching of the DreamCoder for MySQL version 4.7. This version includes a new enhanced and several new characteristics that facilitate and reduce development time.

This is a very useful script when you need drop all the objects in a schema.

Execution process in the DreamCoder for Oracle.

1. Open the script in the SQL Editor.
2. Open the SQL output
3. Execute the script with F9.

 

This is the top five of the most common errors during the connection process to MySQL database server.

1. 2003 Can't connect to MySQL server on.
2. Lost connection to MySQL server during query.
3. 1045 Access denied for user.
4. Host xxx is not allowed to connect to this MySQL.
5. MySQL server has gone away.

The most common error in mysql server is "Can't connect to MySQL server on 'localhost' (10061)", this happen when you attempt to connect to the MySQL database Server.

Why this script?
Most of the FK's defined in an Oracle DB, are not created using the on delete cascade option, since that is (most of the times) not wanted at all.
But sometimes records must be deleted while it is not allowed to do so, because there are child records (or a complete tree of child records) present.
For cases like that I use a script that searches the DB for child recs, using the SYS views.

 One of the most frequent questions we are asked is; how to manipulate the XML Types for DreamCoder for Oracle. Before it was a complicated task to manipulate this type of field since DreamCoder only recognized XML types as a simple text field and only  enabled the edition option in the form view.

DreamCoder for Oracle  includes many changes, such as the way objects are described with the SQL and PL/SQL editor.  

The new DreamCoder for Oracle includes a new way to describe objects or alias when using the SQL and PL/SQL editor, just combine CTRL + CLICK on the object. The advantage of this new option is that the object opens in edition mode, therefore the programming process is quicker. If you are opening a method package, when opened the cursor will be pointing to the method.

One of the most common activities when working with MySQL is exporting and importing data, this article focuses on that while using DreamCoder for MySQL.

I am comparing tables in two different schemas. Since I am doing the same thing over and over again I created a small script which might be useful to you too.

All data types in the Oracle database implement the null value. Null is a very special value which means ‘Unknown’. That means that the value is really unknown. Null is not equal to null, because both are not known. Therefore you cannot compare them to each other.