DreamCoder for Oracle DBA 4.0.7.0

DreamCoder for Oracle DBA 4.0.7.0 offers a program which is a powerful Integrated Development Environment (IDE) for Oracle Databases.

Using the intuitive DreamCoder's GUI will increase your code quality and reduce the development process time.

DreamCoder for Oracle you will easily be able to build and execute queries, build and execute scripts, build and execute PL/SQL code, create and modify database objects, import and export data and user session monitor among others.

DreamCoder for Oracle offers powerful visual tools for increase your productivity like SQL editor, procedure builder, parameter manager, describe objects, LOV viewer and session monitor among others features.

1. Principal features
   
   • Multiple database connections
   • Database registration
   • Direct connection without SQL*Net.
   • Object navigator
   • Contextual tree filters
   • Powerful PL/SQL Editor
   • Procedure Builder
   • Master detail Table browser
   • Parameter Manager
   • Value List for foreign keys
   • Code Inspector
   • Procedure Evaluator
   • Synonym Manager
   • Describe all objects (F4)
   • SQL and PL/SQL Code Formatter(Only Enterprise Edition)
   • Database system monitor (Only Professional Edition)
   • SQL Plus Console
   • Lov Viewer
   • CLOB support
   • Database Session monitor
   • SQL Window
   • Administration of project
   • Object Browser
   • Non-PL/SQL Objects
   • Template List
   • Compare User Objects
   • Export User Objects
   • Advanced Query Builder
   • Describe Object
   • Object Finder
   • Filter of Objects
   • Recycle bin (10g)
   • Object extractor
   • SQL History
   • Database reports
   • Object compiler assistant
   • Support partition tables and partition indexes
   • DML code generator
   • Integrated Debugger (requires Oracle 7.3.4 or later)
   • Account Password Encryption.
   • MDI Interface - Microsoft Office Style
   • Workgroup development
   • Dockable environment
   • Easy installation
2. DBA
   
   • Create/View/Drop /Edit Users
   • Create/View/Drop /Edit Roles
   • Create/View/Drop /Edit Profiles
   • Create/View/Drop /Edit Resource Group
   • Create/View/Drop /Edit Tablespaces
   • Create/View/Drop /Edit Rollback Segments
   • Create/View/Drop /Edit Redo Log Groups
   • Storage Monitor
   • SGA Monitor
3. Synchronization
   
   • Database Data Synchronization
   • Database Structure Synchronization
4. Easy management of all Oracle objects
   
   • Create/View/Drop /Editing tables
   • View/Drop /Drop key, unique, trigger, Indexes and synonyms of the tables
   • Create/View/Drop/Edit Packages
   • Create/View/Drop/Edit Procedures
   • Create/View/Drop/Edit Functions
   • Create/View/Drop/Edit Triggers
   • Create/View/Drop/Edit Jobs
   • Create/View/Drop/Edit Java Objects
   • Create/View/Drop/Edit Object types
   • View/Drop Clusters
   • Create/View/Drop/Edit Synonyms
   • Create/View/Drop/Edit Index
   • Create/View/Drop/Edit Sequences
   • View/Drop Dimensions
   • Create/View/Drop/Edit Links (database)
   • Create/View/Drop SnapShots
   • View/Drop Queue Tables
   • View/Drop Refresh Group
5. View/Drop Security and Storage
   
   • View/Drop Users
   • View/Drop Roles
   • View/Drop Profiles
   • View Datafiles
   • View Tablespaces
   • View Rollback Segments
   • View Redo Log Groups
6. Data Grid Manipulation
   
   • Advanced grid options enable you to copy and paste records from MS Excel , delete selected recods, perform column customization, execute many export options and perform customization.
   • Data Grouping
   • Data Filtering
   • Automatic Sorting
   • Filter Builder
   • Record count
   • Create Summary Data Groups (Sum,Min,Max,Count,Average)
7. PL/SQL processing
   
   • Multiple PL/SQL and SQL Editors
   • Script Executing (PL/SQL Script Editor)
   • SQL Monitor
   • Powerful Print Metadata Module for creating customizable metadata reports
   • Extracting metadata INTO text files or SQL Script editor
8. Powerful data manipulation tools
   
   • Export data in to 14 popular formats like MS Access, MS Excel, MS Word , HTML,XML,TXT, PDF.
   • Import data from in 7 popular formats like MS Excel, MS Access, DBF, XML, TXT and CSV.
   • Export data to SQL script as INSERT statement.
   • Fully customizable program interface
   • Program options: windows, fonts, grid colors, etc.
   • Editors: custom colors, fonts etc.
   • Toolbars for all program windows
   • Powerful Visual Options Module
   • Possibility of saving all the program settings
   • Localizable program interface

Enhancements:

• Old explain plan new option
• Fixed bug with executing stored procedures returning not opened cursor
• Fixed bug with multiples oracle homes list retrieve
• Fixed some minors bugs.

Requirements:

• Windows 95/98/2000/XP/2003/Vista
• 32-bit SQL*Net or Net 8 or Net 9 version (Database Connection)