O'Reilly logo

Oracle PL/SQL Programming, 5th Edition by Bill Pribyl, Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Editing Environments for PL/SQL

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.

ProductDescription

Toad

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/.

SQL Navigator

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/.

PL/SQL Developer

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.

SQL Developer

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required