DreamCoder for Oracle

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
• Manage tables, columns, indexes, foreign keys
• Manage views, materialized views, packages, procedures, functions, triggers, jobs, sequences, synonyms and much more
Data Handling
• Add, view, edit, search, group, sort and filter data
• 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
• Running scripts
• Parameters auto-replace
Options for exporting and importing data
• Simple export of data into a table
Monitoring the database
• Sessions monitor
• History of built and run queries
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