As I mentioned earlier. you can use a “lowest common denominator” editing and execution environment like SQL*Plus or you can use a integrated development environment that offers extensive graphical interfaces to improve your productivity. This section lists some of the most popular of the IDE tools. I do not recommend any particular tool; you should carefully define the list of requirements and priorities you have for such a tool and then see which of them best meets your needs.
Offered by Quest Software, Toad is far and away the most popular PL/SQL IDE. It is used by hundreds of thousands of developers, in both its free and commercial versions. For more information, see http://www.quest.com/toad-for-oracle/.
Also offered by Quest Software, SQL Navigator is also used by tens of thousands of developers who love the product’s interface and productivity features. For more information, see http://www.quest.com/sql-navigator/.
This product is sold by Allround Automations, and is a favorite of many PL/SQL developers. It is built around a plug-in architecture, so third parties can offer extensions to the base product. For more information, see http://www.allroundautomations.com/plsqldev.html.
After years of little or no support for PL/SQL editing, Oracle Corporation created SQL Developer as a “fork” of the foundation JDeveloper tool. SQL Developer is free and increasingly robust. For more information, ...