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