O'Reilly logo

TOAD by Dan Hotka, Bert Scalzo

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

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

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