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, Mac and Windows 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, Autotrace, Schema comparer, Schema exporter, Data comparer, Data copier, Data exporter, Data importer, Session browser