DreamCoder for Oracle is a comprehensive tool for developing and managing an Oracle database.
Features: DreamCoder for Oracle is a comprehensive tool for managing an Oracle database. It includes tools that help you during the development phase of the database too. While it helps DBA community to increase productivity, the developer tools help increase developer productivity in a similar way. The tools and modules included also help manage and develop on the Oracle server. The user interface is quite intuitive; makes it easy to use the program even for complete beginners. All the management and the development functions are deployed from this interface. Build and debug options for SQL as well as PL/SQL code are available. Latest version of Oracle 11g is supported. The application also supports all objects in the database including UTF-8 data. Many types of connections can be set up with the database. These include the standard Oracle OCI connection, direct TCP-IP connection etc.
The product supports Unicode so that multi byte languages could be used quite easily. Comprehensive object management such as create, edit or delete of users, roles, profiles and resource groups are available. Managing tables, columns, indexes and foreign keys, managing views, materialized views, packages, procedures, functions, triggers, table spaces, rollback segments and redo logs are offered. Record/data manipulation features include add, view, edit, search, group, sort and filter data; copy and paste data directly from Excel; delete selected records; export data into SQL inserts, master detail relationships between unlimited number of tables, utility to handle LOV and advanced filter data builder. Visual query builder has features such as SQL editor, SQL query builder, PLO/SQL code formatter and debugger and scripts editor. Large number of import and export options, database monitoring features, synchronizing features, reports and development environment options round off a rich set of features.
Overall: This is an excellent program for managing the development and operation of an Oracle database.