TOAD provides a number of features that make PL/SQL development easy:

  • Keyboard shortcuts

  • Table and column select lists

  • PL/SQL templates

  • Options for creating and executing PL/SQL procedures or parts of procedures

  • Complete debugging capabilities

  • Complete source code control

The Procedure Editor window gives you the ease and flexibility to create and edit PL/SQL no matter where it exists in the database. Figure 4.1 illustrates the Procedure Editor window, displaying a function stored in the database.

Figure 4.1. The TOAD Procedure Editor window.

This illustration shows the default Procedure Editor. The various buttons at the top perform just ...

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.