DreamCoder for Oracle Professional 2.4.2.5

DreamCoder for Oracle Professional 2.4.2.5 offers powerful visual tools for increase your productivity like SQL editor, procedure builder, master detail table browser, database data synchronization, database structure synchronization, parameter manager, code inspector, describe objects, SQL Plus Console, Lov Viewer, object extractor,database reports among others features.

DreamCoder for Oracle is a powerful Integrated Development Environment (IDE) for Oracle Databases. With the intuitive DreamCoders GUI 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, compile and debug SQL and PL/SQL code, create and modify database objects, import and export data, user session monitor, storage monitor, SGA monitor, and database monitor among others.

Major 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.

9. 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:

• Enhanced query Builder, Optimized memory utilization,
• Improved Query Builder usability of building GROUP BY/HAVING clauses,
• Improved Data Synchronization,Improved Structure Synchronization,
• Several minor bugs are fixed.

Requirements:

• DreamCoder for PostgreSQL will run on Windows 95, 98, NT4, 2000, 2003 and XP.
• The supported PostgreSQL Server versions 8 or higher.
• To connect to an Oracle database, DreamCoder only requires a 32-bit SQL*Net or Net 8 or Net 9 version to debugger.