DreamCoder for Oracle is an integrated software to develop and manage Oracle database. DreamCoder combines multiple tools into one and provides you one comprehensive software using which you can do everything. DreamCoder has a freeware version as well, that has some pretty good features, and makes it very easy to do normal database administration activities, as well as do development in Oracle.
Here are some of the features of Free version of DreamCoder:
- Full support of all Oracle versions from 8 and above.
- Comes with an integrated SQL Editor, and Procedure builder.
- SQL Editor has advanced features like SQL Autocomplete, and script execution.
- Object navigator
- Generate table SQL
- Project manager
- Parameter manager
- Session monitor
- Blob viewer
- Data Export
Free version of Dreamcoder can be used for commercial use as well. So, you can use it for your day to day Oracle development and administration related activities, without spending any money. Dreamcoder is pretty good, and works well. If you are looking for a more full featured Oracle development tool, you can try Oracle SQL Developer. Other good option for Free database management and development is TOra.