|
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.
SQL Editor
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.
Projects
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.
Object Navigator
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.
Non-PL/SQL
Objects
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.
Template
List
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.
Object extractor
To export the DDL (Data Definition Language) statements of a selection
of objects of a user, you can use the Export User Objects tool. This
way you can easily recreate the objects for another user, or you can
save the file(s) as a backup.
Tools
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.
System Monitor
DreamCoder includes a set graphics about performance of the database
Platforms supported:
Windows 95, Windows NT, Windows 2000, Windows XP, Windows 98, Windows Server 2003
|
