10g配置isqlplus

1)常用设置及解释

set line 300        ----设置宽度

set pages 3000      ----设置页大小

set timing on       ----打开时间查询

设置前：

SQL> select * from tab;

TNAME                                                                                                                TABTYPE
------------------------------------------------------------ --------------
CLUSTERID
----------
DEPT                                                                                                                 TABLE


EMP                                                                                                                    TABLE


BONUS                                                                                                                TABLE



TNAME                                                                                                                TABTYPE
------------------------------------------------------------ --------------
CLUSTERID
----------
SALGRADE                                                                                                         TABLE


SYS_EXPORT_SCHEMA_01                                                                                 TABLE



SQL>

设置后

SQL> set line 300
SQL> set pages 3000
SQL> set timing on
SQL> select * from tab;

TNAME                                                                                                                TABTYPE                 CLUSTERID
------------------------------------------------------------ -------------- ----------
DEPT                                                                                                                 TABLE
EMP                                                                                                                    TABLE
BONUS                                                                                                                TABLE
SALGRADE                                                                                                         TABLE
SYS_EXPORT_SCHEMA_01                                                                                 TABLE

Elapsed: 00:00:00.02
SQL>

2）帮助命令

SQL> help set                

SET
---

Sets a system variable to alter the SQL*Plus environment settings
for your current session. For example, to:
         -     set the display width for data
         -     customize HTML formatting
         -     enable or disable printing of column headings
         -     set the number of lines per page
In iSQL*Plus, you can also use the Preferences 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}                                     NUM[WIDTH] {10|n}
     ARRAY[SIZE] {15|n}                                             PAGES[IZE] {14|n}
     AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n}            PAU[SE] {OFF|ON|text}
     AUTOP[RINT] {OFF|ON}                                         RECSEP {WR[APPED]|EA[CH]|OFF}
     AUTORECOVERY {OFF|ON}                                        RECSEPCHAR {_|c}
     AUTOT[RACE] {OFF|ON|TRACE[ONLY]}                 SERVEROUT[PUT] {ON|OFF}
         [EXP[LAIN]] [STAT[ISTICS]]                             [SIZE {n | UNLIMITED}] [FOR[MAT]
     BLO[CKTERMINATOR] {.|c|ON|OFF}                         {WRA[PPED] |
     CMDS[EP] {;|c|OFF|ON}                                             WOR[D_WRAPPED] |
     COLSEP {_|text}                                                         TRU[NCATED]}]
     CON[CAT] {.|c|ON|OFF}                                     *SHIFT[INOUT] {VIS[IBLE] |
     COPYC[OMMIT] {0|n}                                                 INV[ISIBLE]}
     COPYTYPECHECK {ON|OFF}                                    *SHOW[MODE] {OFF|ON}
     DEF[INE] {&|c|ON|OFF}                                     *SQLBL[ANKLINES] {OFF|ON}
     DESCRIBE [DEPTH {1|n|ALL}]                             SQLC[ASE] {MIX[ED] |
         [LINENUM {OFF|ON}] [INDENT {OFF|ON}]         LO[WER] | UP[PER]}
     ECHO {OFF|ON}                                                     *SQLCO[NTINUE] {> | text}
    *EDITF[ILE] file_name[.ext]                            *SQLN[UMBER] {ON|OFF}
     EMB[EDDED] {OFF|ON}                                            SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
     ESC[APE] {\|c|OFF|ON}                                     *SQLPRE[FIX] {#|c}
     FEED[BACK] {6|n|ON|OFF}                                 *SQLP[ROMPT] {SQL>|text}
     FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}    SQLT[ERMINATOR] {;|c|ON|OFF}
    *FLU[SH] {ON|OFF}                                                *SUF[FIX] {SQL|text}
     HEA[DING] {ON|OFF}                                            *TAB {ON|OFF}
     HEADS[EP] {||c|ON|OFF}                                    *TERM[OUT] {ON|OFF}
     INSTANCE [instance_path|LOCAL]                    *TI[ME] {OFF|ON}
     LIN[ESIZE] {80|n} ({150|n} iSQL*Plus)        TIMI[NG] {OFF|ON}
     LOBOF[FSET] {1|n}                                             *TRIM[OUT] {ON|OFF}
     LOGSOURCE [pathname]                                        *TRIMS[POOL] {OFF|ON}
     LONG {80|n}                                                            UND[ERLINE] {-|c|ON|OFF}
     LONGC[HUNKSIZE] {80|n}                                     VER[IFY] {ON|OFF}
     MARK[UP] HTML [OFF|ON]                                     WRA[P] {ON|OFF}
         [HEAD text] [BODY text] [TABLE text]     XQUERY {BASEURI text|
         [ENTMAP {ON|OFF}]                                                ORDERING{UNORDERED|
         [SPOOL {OFF|ON}]                                                                    ORDERED|DEFAULT}|
         [PRE[FORMAT] {OFF|ON}]                                     NODE{BYVALUE|BYREFERENCE|
     NEWP[AGE] {1|n|NONE}                                                        DEFAULT}|
     NULL text                                                                    CONTEXT text}
     NUMF[ORMAT] format


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


SQL>

本文出自 “Focus on Oracle” 博客，请务必保留此出处http://alexy.blog.51cto.com/6115453/1072381