Using iSQL*Plus
Quick Start
User Interface
Configuring iSQL*Plus
Using iSQL*Plus
Creating Dynamic Reports
iSQL*Plus Server
Statistics
Security
Globalization Support
Copyright Information
SQL*Plus
Readme*
SQL*Plus
FAQ*
Oracle9i Syntax
Oracle9i
Documentation Library*
SQL
& PL/SQL Commands*
*Links require internet connection to the Oracle
Technology Network.
|
Command Syntax
@ ("at" sign)
@@ (double "at" sign)
/ (slash)
ARCHIVE LOG
ATTRIBUTE
BREAK
BTITLE
CLEAR
COLUMN
COMPUTE
CONNECT
DEFINE
DESCRIBE
DISCONNECT
EXECUTE
EXIT
HELP
LIST
PRINT
PROMPT
RECOVER
REMARK
REPFOOTER
REPHEADER
RUN
SET
SHOW
SHUTDOWN
START
STARTUP
TIMING
TTITLE
UNDEFINE
VARIABLE
WHENEVER OSERROR
WHENEVER SQLERROR
|
SET Command Syntax
SET APPINFO{ON|OFF|text}
SET ARRAYSIZE {15|n}
SET AUTOCOMMIT{ON|OFF|IMMEDIATE|n}
SET AUTOPRINT {ON|OFF}
SET AUTORECOVERY [ON|OFF]
SET AUTOTRACE {ON|OFF|TRACE[ONLY]}
[EXPLAIN] [STATISTICS]
SET BLOCKTERMINATOR {.|c|ON|OFF}
SET CMDSEP {;|c|ON|OFF}
SET COLSEP {_|text}
SET COMPATIBILITY{V7|V8|NATIVE}
SET CONCAT {.|c|ON|OFF}
SET COPYCOMMIT {0|n}
SET COPYTYPECHECK {ON|OFF}
SET DEFINE {&|c|ON|OFF}
SET DESCRIBE [DEPTH {1|n|ALL}][LINENUM
{ON|OFF}][INDENT {ON|OFF}]
SET ECHO {ON|OFF}
SET EMBEDDED {ON|OFF}
SET ESCAPE {\|c|ON|OFF}
SET FEEDBACK {6|n|ON|OFF}
SET FLAGGER {OFF|ENTRY |INTERMEDIATE|FULL}
SET HEADING {ON|OFF}
SET HEADSEP {||c|ON|OFF}
SET INSTANCE [instance_path|LOCAL]
SET LINESIZE {80|n}
SET LOBOFFSET {n|1}
SET LOGSOURCE [pathname]
SET LONG {80|n}
SET LONGCHUNKSIZE {80|n}
SET MARKUP HTML [ON|OFF] [HEAD
text] [BODY text] [TABLE text] [ENTMAP {ON|OFF}][SPOOL {ON|OFF}] [PREFORMAT
{ON|OFF}]
SET NULL text
SET NUMFORMAT format
SET NUMWIDTH {10|n}
SET PAGESIZE {24|n}
SET RECSEPCHAR {_|c}
SET RECSEP {WRAPPED|EACH|OFF}
SET SERVEROUTPUT {ON|OFF} [SIZE
n] [FORMAT {WRAPPED|WORD_WRAPPED|TRUNCATED}]
SET SQLCASE {MIXED|LOWER|UPPER}
SET SQLPLUSCOMPATIBILITY {x.y[.z]}
SET SQLTERMINATOR {;|c|ON|OFF}
SET TIM[NG {ON|OFF}
SET UNDERLINE {-|c|ON|OFF}
SET VERIFY {ON|OFF}
SET WRAP {ON|OFF}
|
