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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/802415/viewspace-823067/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/802415/viewspace-823067/