- 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
SQL*Plus Compatibility
SQL*Plus is used for a variety of things in the Oracle environment. In the early days (version 5 and before), SQL*Plus was also used as an administrative tool. Today, SQL*Plus has taken back the Server Manager role. SQL*Plus has always been a good character-mode reporting tool, a tool used to create SQL-creating-SQL (next topic in this chapter), and so on. It is quite powerful with its formatting and file creation (spool commands) to perform a variety of tasks in the Oracle environment.
TOAD is an excellent tool for creating and maintaining these SQL*Plus scripts. The Script Output tab in the results panel is powerful in that you can see what the script has produced without having to leave TOAD and run the script in a separate window with SQL*Plus.
TOAD primarily supports the reporting features of SQL*Plus and not the administrative functions that have been given back to SQL*Plus.
TIP
Make sure to run any SQL*Plus script as a script!
TOAD supports these SQL*Plus commands:
TOAD simply ignores the following SQL*Plus commands:
and any other SET commands not supported by TOAD.
The following SQL*Plus commands are NOT supported in TOAD:
ACCEPT |
APPEND |
ARCHIVE LOG |
ATTRIBUTE |
BTITLE/TTITLE |
|
CHANGE |
COPY |
DEL |
EDIT |
EXECUTE |
GET |
HELP |
HOST |
INPUT |
LIST |
PASSWORD |
|
RECOVER |
REPHEADER/REPFOOTER |
|
SAVE |
SHOW |
SHUTDOWN |
START |
STARTUP |
|
TIMING |
VARIABLE |
|
WHENEVER OSERROR |
WHENEVER SQLERROR |
|