sqlplus-help[@more@]

SQL> help

HELP
----

Accesses this command line help system. Enter HELP INDEX for a list
of topics.
In iSQL*Plus, click the Help button to display iSQL*Plus help.

HELP [topic]

SQL> help index

Enter Help [topic] for help.

@ COPY PAUSE SHUTDOWN
@@ DEFINE PRINT SPOOL
/ DEL PROMPT SQLPLUS
ACCEPT DESCRIBE QUIT START
APPEND DISCONNECT RECOVER STARTUP
ARCHIVE LOG EDIT REMARK STORE
ATTRIBUTE EXECUTE REPFOOTER TIMING
BREAK EXIT REPHEADER TTITLE
BTITLE GET RESERVED WORDS (SQL) UNDEFINE
CHANGE HELP RESERVED WORDS (PL/SQL) VARIABLE
CLEAR HOST RUN WHENEVER OSERROR
COLUMN INPUT SAVE WHENEVER SQLERROR
COMPUTE LIST SET
CONNECT PASSWORD SHOW

SQL> help set

SET
---

Sets a system variable to alter the SQL*Plus environment settings
for your current session, for example:
- display width for data
- turn on HTML formatting
- enabling or disabling printing of column headings
- number of lines per page

In iSQL*Plus, you can also use the System Variables screen to set
system variables.

SET system_variable value

where system_variable and value represent one of the following clauses:

APPI[NFO]{OFF|ON|text}
ARRAY[SIZE] {15|n}
AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n}
AUTOP[RINT] {OFF|ON}
AUTORECOVERY {ON|OFF}
AUTOT[RACE] {OFF|ON|TRACE[ONLY]}
[EXP[LAIN]] [STAT[ISTICS]]
BLO[CKTERMINATOR] {.|c}
CMDS[EP] {;|c|OFF|ON}
COLSEP {_|text}
COM[PATIBILITY] {V7|V8|NATIVE}
CON[CAT] {.|c|OFF|ON}
COPYC[OMMIT] {0|n}
COPYTYPECHECK {OFF|ON}
DEF[INE] {&|c|OFF|ON}
DESCRIBE [DEPTH {1|n|ALL}]
[LINENUM {ON|OFF}] [INDENT {ON|OFF}]
ECHO {OFF|ON}
*EDITF[ILE] file_name[.ext]
EMB[EDDED] {OFF|ON}
ESC[APE] {|c|OFF|ON}
FEED[BACK] {6|n|OFF|ON} 是否顯示查詢結果的記錄數
FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}
*FLU[SH] {OFF|ON}
HEA[DING] {OFF|ON}
HEADS[EP] {||c|OFF|ON}
INSTANCE [instance_path|LOCAL]
LIN[ESIZE] {80|n} ({150|n} iSQL*Plus)
LOBOF[FSET] {n|1}
LOGSOURCE [pathname]
LONG {80|n}
LONGC[HUNKSIZE] {80|n}
MARK[UP] HTML [ON|OFF]
[HEAD text] [BODY text] [TABLE text]
[ENTMAP {ON|OFF}]
[SPOOL {ON|OFF}]
[PRE[FORMAT] {ON|OFF}]
*NEWP[AGE] {1|n|NONE}
NULL text
NUMF[ORMAT] format
NUM[WIDTH] {10|n}
PAGES[IZE] {24|n}
*PAU[SE] {OFF|ON|text}
RECSEP {WR[APPED] |
EA[CH]|OFF}
RECSEPCHAR {_|c}
SERVEROUT[PUT] {OFF|ON}
[SIZE n] [FOR[MAT]
{WRA[PPED] |
WOR[D_WRAPPED] |
TRU[NCATED]}]
*SHIFT[INOUT] {VIS[IBLE] |
INV[ISIBLE]}
*SHOW[MODE] {OFF|ON}
*SQLBL[ANKLINES] {ON|OFF}
SQLC[ASE] {MIX[ED] |
LO[WER] | UP[PER]}
*SQLCO[NTINUE] {> | text}
*SQLN[UMBER] {OFF|ON}
SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
*SQLPRE[FIX] {#|c}
*SQLP[ROMPT] {SQL>|text}
SQLT[ERMINATOR]
{;|c|OFF|ON}
*SUF[FIX] {SQL|text}
TAB {OFF|ON}
TERM[OUT] {OFF|ON}
TI[ME] {OFF|ON}
TIMI[NG] {OFF|ON}
TRIM[OUT] {OFF|ON}
TRIMS[POOL] {ON|OFF}
UND[ERLINE] {-|c|ON|OFF}
VER[IFY] {OFF|ON} 是否顯示變數的原值和新值
WRA[P] {OFF|ON}

An asterisk (*) indicates the SET option is not supported in iSQL*Plus.