Online Tutorials & Training Materials |
Register Login

DreamCoder for Oracle - Description

|| || 1

DreamCoder for Oracle - Description

DreamCoder for Oracle 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 easily enables you 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, enable user session monitoring and database monitoring among other features.

DreamCoder for Oracle offers powerful visual tools to increase your productivity such as a SQL editor, procedure builder, master detail table browser, parameter manager, code inspector, describe objects, SQL Formatter, SQL Plus Console, Lov Viewer, object extractor, database reports and more.

Principal features

  • 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)

  • Direct connection without SQL*Net.

  • Account Password Encryption.

  • MDI Interface - Microsoft Office Style

  • Workgroup development

  • Dockable environment

  • Easy installation


  • 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


  • Database Data Synchronization

  • Database Structure Synchronization

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

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

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)

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

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

System requirements
DreamCoder will run on Windows 95, 98, NT4, 2000, 2003 and XP. The supported Oracle Server versions are 8i, 9i and 10g on any platform. To connect to an Oracle database, DreamCoder only requires a 32-bit SQL*Net or Net 8 or Net 9 version to debugger.

Trial version
You can download a fully functional 30-day trial version to try out DreamCoder yourself. If after 30 days you can't imagine how you’ve ever been able to work without DreamCoder, you can visit our ordering page for ordering details and price information.


  • 20 Dec 2008 10:06 am
    how could i export the data to excel

Related Articles