Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.1, a powerful oracle database tool for administration and development.

Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with oracle databases.

 Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.0.7.0.

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.

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.

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.

I came across the need to define the first day of next month based on the current systemdate. I can do this using the following code:

add_months(to_date(’01'||to_char(sysdate,’MMYYYY’),’DDMMYYYY’),1)

But the I remembered that there was a post on the oracledeveloper.nl forum with similar date functions.

If you don’t know where to start your with your program, recursion might be an option. I am working on some (perhaps useless) package code to convert an integer into a boolean representation. When I am converting the integer, I don’t know where to start my conversion. If the integer is relatively small and I start with a high bit (too big) then the overhead is relatively big.