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 . You won't need to buy separate tools or complex Studios which make everyday work more complex and difficult.
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 both in commercial and freeware version.
DreamCoder for Oracle is available in both commercial and freeware version.
DreamCoder for Oracle View demo | Download | Get quote
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
|