ITPub博客

首页 > 数据库 > Oracle > sqlplus-help

sqlplus-help

原创 Oracle 作者:chance2000 时间:2006-03-26 00:36:59 0 删除 编辑
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.

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

请登录后发表评论 登录
全部评论
  • 博文量
    78
  • 访问量
    835317