Home > Articles > Data > Oracle

TOAD SQL Editor

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

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:

@ ("at" sign)
@@ (double "at" sign)
/ (slash)
BREAK (BRE) partial support
CLEAR
COLUMN (partial support, including: ALIAS, NOPRINT/PRINT, NEW_VALUE)
COMPUTE (partial support including: SUM, MIN, MAX)
DEFINE
DESCRIBE
HEADING
JUSTIFY
SPOOL <Filename>, SPOOL OFF, and SPO. Non-qualified files are created in the <TOAD Home Directory>\TEMPS\ directory. Relative-location file creation is supported.
SET AUTOTRACE
SET ECHO (ON/OFF)
SET ESCAPE (ON/OFF)
SET ESCAPE/ESC '\' (\ is any character)—defaults to \
SET HEADING/HEA (ON/off)
SET FEEDBACK (ON/off)
SET LINESIZE
SET SERVEROUTPUT/SERVEROUT (ON/OFF)
SET TERM (ON/off)
DEFINE/DEF and UNDEFINE/UNDEF
PAUSE
EXIT/QUIT
PROMPT/PRO
CONNECT/CON and DISCONNECT/DISC.
REM/REMARK
RUN

TOAD simply ignores the following SQL*Plus commands:

SET TAB
STORE SET
VERIFY
PAGESIZE

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

 


  • + Share This
  • 🔖 Save To Your Account