Sql*Plus User’s Guide and Reference

REPHEADER
........................................................................................................................................ 12-83
RUN
........................................................................................................................................................ 12-86
SAVE
...................................................................................................................................................... 12-87
SET
......................................................................................................................................................... 12-88
SET System Variable Summary
........................................................................................................ 12-89
SET APPI[NFO]{ON | OFF | text} ............................................................................................. 12-92
SET ARRAY[SIZE] {15 | n}.......................................................................................................... 12-93
SET AUTO[COMMIT]{ON | OFF | IMM[EDIATE] | n} ....................................................... 12-94
SET AUTOP[RINT] {ON | OFF}................................................................................................. 12-95
SET AUTORECOVERY [ON | OFF] .......................................................................................... 12-96
SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]........... 12-97
SET BLO[CKTERMINATOR] {. | c | ON | OFF} .................................................................... 12-98
SET CMDS[EP] {; | c | ON | OFF}............................................................................................. 12-99
SET COLINVI[SIBLE] [ON | OFF]........................................................................................... 12-100
SET COLSEP {  | text} ................................................................................................................. 12-101
SET CON[CAT] {. | c | ON | OFF}.......................................................................................... 12-102
SET COPYC[OMMIT] {0 | n} .................................................................................................... 12-103
SET COPYTYPECHECK {ON | OFF} ...................................................................................... 12-104
SET DEF[INE] {& | c | ON | OFF} .......................................................................................... 12-105

---

ix
SET DESCRIBE [DEPTH {1 | n | ALL}] [LINENUM {ON | OFF}] [INDENT {ON | OFF}]..........
12-106
SET ECHO {ON | OFF}.............................................................................................................. 12-107
SET EDITF[ILE] file_name[.ext] .................................................................................................. 12-108
SET EMB[EDDED] {ON | OFF} ................................................................................................ 12-109
SET ERRORL[OGGING] {ON | OFF} [TABLE [schema.]tablename] [TRUNCATE] [IDENTIFIER 
identifier] 12-110
SET ESC[APE] {\ | c | ON | OFF}........................................................................................... 12-115
SET ESCCHAR {@ | ? | % | $ | OFF} ..................................................................................... 12-116
SET EXITC[OMMIT] {ON | OFF}............................................................................................. 12-117
SET FEED[BACK] {6 | n | ON | OFF} .................................................................................... 12-118
SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}.......................................... 12-119
SET FLU[SH] {ON | OFF}.......................................................................................................... 12-120
SET HEA[DING] {ON | OFF} ................................................................................................... 12-121
SET HEADS[EP] {  | c | ON | OFF} ........................................................................................ 12-122
SET INSTANCE [instance_path | LOCAL] .............................................................................. 12-123
SET LIN[ESIZE] {80 | n}............................................................................................................. 12-124
SET LOBOF[FSET] {1 | n} .......................................................................................................... 12-125
SET LOGSOURCE [pathname] ................................................................................................... 12-126
SET LONG {80 | n} ..................................................................................................................... 12-127
SET LONGC[HUNKSIZE] {80 | n}........................................................................................... 12-128
SET MARK[UP] HTML [ON | OFF] [HEAD text] [BODY text] [TABLE text] [ENTMAP {ON | 
OFF}] [SPOOL {ON | OFF}] [PRE[FORMAT] {ON | OFF}] 12-129
SET NEWP[AGE] {1 | n | NONE} ........................................................................................... 12-131
SET NULL text ............................................................................................................................. 12-132
SET NUMF[ORMAT] format...................................................................................................... 12-133
SET NUM[WIDTH] {10 | n} ...................................................................................................... 12-134
SET PAGES[IZE] {14 | n} ........................................................................................................... 12-135
SET PAU[SE] {ON | OFF | text} ............................................................................................... 12-136
SET RECSEP {WR[APPED] | EA[CH] | OFF} ....................................................................... 12-137
SET RECSEPCHAR {  | c} .......................................................................................................... 12-138
SET SECUREDCOL {OFF | ON} [UNAUTH[ORIZED] text] [UNK[NOWN] text] .......... 12-139
SET SERVEROUT[PUT] {ON | OFF} [SIZE {n | UNL[IMITED]}] [FOR[MAT] {WRA[PPED]
| WOR[D_WRAPPED] | TRU[NCATED]}] 12-140
SET SHIFT[INOUT] {VIS[IBLE] | INV[ISIBLE]} .................................................................... 12-142
SET SHOW[MODE] {ON | OFF}.............................................................................................. 12-143
SET SQLBL[ANKLINES] {ON | OFF} ..................................................................................... 12-144
SET SQLC[ASE] {MIX[ED] | LO[WER] | UP[PER]} ............................................................. 12-145
SET SQLCO[NTINUE] {> | text}.............................................................................................. 12-146
SET SQLN[UMBER] {ON | OFF} ............................................................................................. 12-147
SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]} ............................................................................. 12-148
SET SQLPRE[FIX] {# | c}............................................................................................................ 12-150
SET SQLP[ROMPT] {SQL> | text} ............................................................................................ 12-151
SET SQLT[ERMINATOR] {; | c | ON | OFF} ........................................................................ 12-152
SET SUF[FIX] {SQL | text} ......................................................................................................... 12-153
SET TAB {ON | OFF}.................................................................................................................. 12-154
SET TERM[OUT] {ON | OFF}................................................................................................... 12-155
SET TI[ME] {ON | OFF}............................................................................................................. 12-156

---

x
SET TIMI[NG] {ON | OFF}........................................................................................................ 12-157
SET TRIM[OUT] {ON | OFF} .................................................................................................... 12-158
SET TRIMS[POOL] {ON | OFF} ............................................................................................... 12-159
SET UND[ERLINE] {- | c | ON | OFF}................................................................................... 12-160
SET VER[IFY] {ON | OFF}......................................................................................................... 12-161
SET WRA[P] {ON | OFF}........................................................................................................... 12-162
SET XMLOPT[IMIZATIONCHECK] [ON|OFF] ................................................................... 12-163
SET XQUERY BASEURI {text}................................................................................................... 12-164
SET XQUERY ORDERING {UNORDERED | ORDERED | DEFAULT} ........................... 12-165
SET XQUERY NODE {BYVALUE | BYREFERENCE | DEFAULT}................................... 12-166
SET XQUERY CONTEXT {text}................................................................................................. 12-167
SHOW
.................................................................................................................................................. 12-168