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