OraExp is a free Oracle IDE that targets to be lightweight and easy to use. Currently it is oriented mainly towards software developers. It works on Linux and Windows (should theoretically work on Mac as well, though not tested yet) and supports Oracle 9i and later.
Below is list of currently supported features:
- Full unicode support
- Creators/Editors/Viewers for following object types: Relational tables, Views, Packages, Procedures, Functions, Triggers, Sequences, Types, Synomyms, Database links, Users
- Worksheet with support for bind parameters (including cursors) and multiple resultsets
- DBMS output
- Explain plan
- Schema comparer
- Schema exporter
- Data comparer
- Data copier
- Data exporter
- Data importer
- Session browser
The main reason I like in OraExp is "LightWeight".