DreamCoder for Oracle (FREE Oracle Tool)


DreamCoder for Oracle
News | Requirements | View demo | Screenshots | FAQ | Testimonials

DreamCoder for Oracle is a comprehensive tool for developing and managing an Oracle database. This product increases the productivity and quality of development teams and database administrators (DBAs).

In DreamCoder for Oracle you will find different tools and modules to manage and develop an Oracle database server .

DreamCoder for Oracle provides an intuitive interface that allows you to perform database tasks quickly and easily. DreamCoder for Oracle has all the features that allow you to quickly and easily perform all development and management through its intuitive interface which includes the most advanced options to build and debug SQL and PL / SQL code. Other features included facilitate the process to create, publish, duplicate, export and delete objects, compile and run stored procedures, export and import data, generate reports, monitor the activity of the database, synchronize the database, build and run queries, format the SQL and PL / SQL code, handle BLOB and CLOB and many other features.

It supports Oracle database server from version 8 to version 11g and each of the new features included. DreamCoder for Oracle is one of the favorite products of Oracle developers worldwide and is available in afreeware version.

Feature List

    Supports all versions of Oracle database server (8i, 9i, 10g, 11g)

  • Supports the latest Oracle version 11g
  • Supports all objects in the database
  • Supports UTF-8 data
  • Multiple types of connection to the database
  • Standard Oracle OCI Connection
  • Direct TCP-IP connection - no need for OIC
  • Supports unicode
  • Comprehensive object management
  • Create, edit and delet users, roles, profiles and resource groups
  • Manage tables, columns, indexes, foreign keys
  • Manage views, materialized views, packages, procedures, functions, triggers, jobs, sequences, synonyms and much more
  • Manage tablespaces, rollback segments and redo log
  • Data Handling
  • Add, view, edit, search, group, sort and filter data
  • Ability to copy and paste data directly from Excel
  • Ability to delete selected records
  • Able to export data into SQL inserts
  • Able to create master detail relationships between unlimited number of tables
  • Utility to handle LOV
  • Advanced filter data builder
  • Advanced builder for visual queries and text
  • Advanced SQL editor with autocomplete, syntax highlighting, code folding, objetcs description, code proposal and parameters manager
  • Advanced query builder to build SQL's without previous knowledge required
  • Advanced PL/SQL debugger
  • SQL and PL/SQL code formatter
  • Running scripts
  • Parameters auto-replace
  • Options for exporting and importing data
  • Utility to export data from database
  • Utility to transfer data from the database
  • Utility to export in multiple formats (MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF)
  • Utility to import in multiple formats (MS Excel, MS Access, DBF, XML, ODF, TXT and CSV)
  • Advanced options for export and import at the level of the data grid
  • Utility to import data directly from Excel
  • Simple export of data into a table
  • Monitoring the database
  • System monitor
  • Sessions monitor
  • User monitor
  • SGA Monitor
  • Storage Monitor
  • History of built and run queries
  • Advanced options for synchronizing the database
  • Utility to synchronize schemas of two databases
  • Utility to synchronize data in two schemas
  • Reports module
  • Multiple database reports
  • IDE adapt options
  • Comprehensive options to modify the behavior of the IDE
  • Comprehensive options to modify the behavior of the SQL editor
  • Comprehensive options to modify the behavior of the data grid


Why DreamCoder

DreamCoder is downloaded over 1 millions time and has accumulated over 10.000 happy customers from over 100 countries in the last 8 years.
Now we are the best database tools availabe 100% free in the world for Oracle , MySQL and PostgreSQL.
Home Products DreamCoder for Oracle