You can use DreamCoder for Oracle Free Edition software/tool to get an ide and administration tool for your oracle databases.
DreamCoder for Oracle Free Edition is a free powerful Integrated Development Environment (IDE) and administration tool for Oracle Databases. With the intuitive DreamCoder's GUI increase your code quality and reduce the development process time. Version 3 build 3.0.2.5 has old explain plan new option, fixed bug with executing stored procedures returning not opened cursor, fixed bug with multiples oracle homes list retrieve, and fixed some minors bugs.