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

3. SQL Editor

The SQL Editor is the original development area of TOAD. This window allows you to type, execute, run, save, reload, examine the explain plan, and tune SQL statements. In this chapter, you will learn how to use TOAD to create and execute SQL scripts, and save both the scripts and the output. This chapter discusses and illustrates the major options available in the SQL Editor.

Basic Concepts of the SQL Editor

TOAD makes SQL development easy in a number of ways:

• Keyboard shortcuts

• Table and column pick lists

• SQL templates

• Ability to create/execute SQL scripts

• Ability to review/edit/save result-set data

• Compatibility with SQL*Plus

The Editor window is the basis of the entire TOAD tool, giving you the ability to create, ...

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