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