DreamCoder for Oracle Free Edition 4.1

DreamCoder for Oracle Free Edition 4.1 offers users a professional and easy-to-use software which is a free powerful Integrated Development Environment (IDE) and administration tool for Oracle Databases. 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).

With the intuitive DreamCoder's GUI increase your code quality and reduce the development process time. DreamCoder for Oracle you will easily be able to build and execute queries, build and execute scripts, build and execute PL/SQL code, create and modify database objects, import and export data and user session monitor among others. DreamCoder for Oracle offers powerful visual tools for increase your productivity like SQL editor, procedure builder, parameter manager, describe objects, LOV viewer and session monitor among other features.

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.

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.

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

Enahncements:

• New Query builder
• Enhanced SQL editor

Requirements:

• 300-megahertz (MHz) Pentium II-compatible processor or higher, 600 - megahertz (MHz) or faster.
• Microsoft Windows NT4, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista.
• 256 MB RAM or higher, 1024 MB recommended.
• 48 MB of disk available to complete installation.
• Super VGA (800x600) or higher, VGA (1024x768) recommended.
• Possibility to connect to a local or remote Oracle database server.