4. TOAD PL/SQL Editor

The PL/SQL Editor is a better editing environment for PL/SQL procedures, functions, packages, and database triggers than the SQL Editor described in Chapter 3. This editor contains a PL/SQL debugger, which is a full-featured symbolic debugger, and a profiler, which tells how long each line of PL/SQL code took to execute (critical information when you are tuning PL/SQL).

The PL/SQL Editor enables you to develop, save, run, debug, profile, and tune PL/SQL wherever it appears in applications or the database.

Basic Concepts of the PL/SQL Editor

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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.