- Overview
- Predefined Shortcuts
- User-Defined Shortcuts
- Using Variables
- Table and Column Name Select Lists
- Using Aliases and Autoreplacement Substitutions
- SQL Templates
- Code Completion Templates
- Executing SQL Statements
- Executing SQL Scripts
- Editing Result-Set Data
- Saving Result-Set Data
- Printing Result-Set Data
- Examining Explain Plans
- Examining Basic Performance Info
- Using Auto Trace
- SQL*Plus Compatibility
- Scripts That Write Scripts
- Summary
Summary
This chapter covered using the TOAD SQL Editor, illustrating most of the features available. The real power in using TOAD is to get comfortable with the various keyboard shortcuts and to set up appropriate aliases and autoreplacements to aid the developer in the development cycle of SQL statements and SQL scripts.
The next chapter covers the TOAD Procedure Editor. Some of the features may appear similar to those features discussed in this chapter. In fact, some of the features are the same or similar. This book will make the distinction clear and use examples that are appropriate for the editor that the developer is using.