DreamCoder empowers developers to be more productive by providing an intuitive graphical user interface to Oracle. DreamCoder is a powerful, low-overhead tool that makes PL/SQL development faster and easier.
Advanced editors allow users to work on multiple files simultaneously — even different file types such as SQL, PL/SQL, Java and text. Hot keys, syntax highlighting and numerous other productivity features speed development, while editing and testing are made easier with integrated result sets, explain plans, tracing, and DBMS_OUTPUT views.
Powerful PL/SQL Editor
With its Syntax Highlighting, SQL and PL/SQL help, Code Assistant, Code Contents and many other sophisticated features, the editor will even appeal to the most demanding user. Information is automatically presented to you when you need it, or is at most one click away.
Integrated Debugger (requires Oracle 7.3.4 or later)
The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it.
The SQL Editor allows you to enter any SQL statement and view or edit the results in a grid, which supports a Query By filter mode to search specific records in a result set. You can easily recall previously executed SQL statements. The SQL editor provides the same powerful features as the PL/SQL Editor.
To generate reports against the results in a grid and saved in several type files includes HTML, TXT, PDF, EXCEL and others. This makes it very easy to run your own frequently used custom reports.
To organize your work you can use DreamCoder built-in project concept. A project consists of a collection of source files, database objects, notes, and options. It allows you to work within the scope of a specific set of items, instead of a complete database or schema. This makes it easy to find the project items you need, to compile all project items.
This configurable tree-view displays all information that is relevant to PL/SQL development. Use it to get object descriptions, to view object definitions, to create test scripts for the debugger, to enable and disable triggers and constraints, to recompile invalid objects, to query or edit table or view data, to search for text in object sources, to drag and drop object names into an editor, and so on.
You can view and modify tables, sequences, synonyms, libraries, directories, users and roles without using any SQL. Just enter the information in an easy to use form, and DreamCoder will generate the appropriate SQL to create or alter the object.
DreamCoder Template List can be a real time-saver and can help you enforce standardization. Whenever you need to insert some standard SQL or PL/SQL code into an editor, and whenever you need to create a new program file from scratch, just click on the corresponding template.
To export the DDL (Data Definition Language) statements of a selection of objects of a user, you can use the Object Extractor
tool. This way you can easily recreate the objects for another user, or you can save the file(s) as a backup.
DreamCoder includes several tools to make everyday development easier. You can recompile all invalid objects, search for text in database sources, import and export tables, view session information, and so on.
DreamCoder includes a set graphics about performance of the database