-
Title
What SQL Plus commands are supported by Toad? -
Description
What SQL Plus commands are supported by Toad?
-
Cause
Toad does not support all SQL*Plus commands. The lists below describe the commands Toad supports, ignores, or does not support.
-
Resolution
SQL*Plus Syntax - Supported
SQL*Plus commands supported by Toad include:
@ and @@
/ (slash) - Required as a separator between certain commands (anonymous blocks, PL/SQL, and Create Type statements)
This does not run the contents of the buffer, because Toad does not store a command buffer as SQL*Plus does.
& (ampersand)
&&(2 ampersands)
ACCEPT
BREAK/BRE
BTITLE/BTI
CLEAR
- CLEAR SCREEN not supported
- SQL not supported
- BUFFER not supported
COLUMN/COL
COMPUTE/COMP
- SUM, MIN, and MAX supported at one level of detail
CONNECT/CON and DISCONNECT/DISC
DEFINE/DEF and UNDEFINE/UNDEF
- CONNECT IDENTIFIER not supported
- SQLPLUS RELEASE not supported
- EDITOR not supported
EXEC/EXECUTE
EXIT/QUIT
HOST
MERGE
PAUSE/PAU
PASSWORD
PROMPT/PRO
PRINT
REM/REMARK
REPFOOTER
REPHEADER
SET APPINFO (only changes the module name when running scripts)
SET AUTOCOMMIT
SET AUTOPRINT
SET AUTOTRACE/AUTOT (default OFF)
SET COLSEP
SET DEFINE/DEF (default ON)
SET ECHO (default OFF)
SET ESCAPE/ESC
SET FEEDBACK/FEED
SET HEADING/HEA (default ON)
SET HEADSEP
SET LINESIZE/LINES (default 80, maximum 2000)
SET LONG
SET LONGCHUNK SIZE
SET NEWPAGE
SET NULL
SET NUMFORMAT
SET NUMWIDTH
SET PAGESIZE
SET RECSEP
SET RECSEPCHAR
SET SCAN (default ON)
SET SERVEROUTPUT/SERVEROUT (default OFF)
- ON and OFF supported
- SIZE supported
SET SHOW
SET SQLCONTINUE
SET SQLNUMBER
SET SQLPROMPT
SET SQLTERMINATOR
SET TERMOUT/TERM (default ON)
SET TIMING
SET TRIMOUT
SET TRIMSPOOL
SET UNDERLINE
SET VERIFY
SET WRAP
SHOW
SPOOL Filename and SPOOL OFF (also SPO).
- In Toad, non-pathed files are created in the Toad directory.
- In Toad Script Runner, non-pathed files are created in the same directory as Toad Script Runner.
- Supports relative spool paths
- Like SQL*Plus, passes SPOOL file to sub-scripts
START
STORE SET
TTITLE
VARIABLE
WHENEVER OSERRER
WHENEVER SQLERROR
SQL*Plus Syntax - Ignored
These commands are ignored, but do not cause an error.
SET ARRAYSIZE
SET DESCRIBE
SET MARKUP
SET AUTORECOVERY
SET EDITFILE
SET PAUSE
SET BLOCKTERMINATOR
SET EMBEDDED
SET SHIFTINOUT
SET CMDSEP
SET FLAGGER
SET SQLBLANKLINES
SET COMPATIBILITY
SET FLUSH
SET SQLCASE
SET CONCAT
SET INSTANCE
SET SQLPREFIX
SET COPYCOMMIT
SET LOBOFFSET
SET SUFFIX
SET COPYTYPECHECK
SET LOGSOURCE
SET TAB
SET TIME
SQL*Plus - Unsupported
These SQL*Plus commands will cause a "Statement Ignored" error on the Script Output tab.
APPEND
COPY
LIST
ARCHIVE LOG
DEL
RECOVER
ATTRIBUTE
EDIT
RUN
CHANGE
GET
SAVE
CLEAR SCREEN
HELP
SHUTDOWN
CLEAR SQL
INPUT
STARTUP
CLEAR BUFFER
(Collected from Toad for Oracle 12.6 Help | "SQL*Plus Commands".)