DreamCoder for Oracle
Date: Wed, 17 Sep 2003 19:59:04 +0400
Message-ID: <ptesone.tx2hh_at_time.usenet.com>
New DreamCoder for Oracle
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.
Project Manager
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 Object Extractor
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.
Mentat Technologies website :
http://www.mentattech.com
--
ptesone
ptesone's Profile: http://www.soft-forum.com/forums/member.php?action=getinfo&userid=517 View this thread: http://www.soft-forum.com/forums/showthread.php?threadid=954229 Received on Wed Sep 17 2003 - 17:59:04 CEST