SET system_variable value

2.11.6 SET system_variable value

Sets a system variable to alter the SQLcl 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

Enter a system variable followed by a value as shown below:

SET APPI[NFO] {ON | OFF | text}
SET ARRAY[SIZE] {15 | n}
SET AUTO[COMMIT] {ON | OFF | IMM[EDIATE] | n}
SET AUTOP[RINT] {ON | OFF}
SET AUTORECOVERY {ON | OFF]
SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]}
SET BLO[CKTERMINATOR] {. | c | ON | OFF}
SET CLASSIC [ ON | OFF ]
SET CLEAR [ TOP | BOTTOM | SAME ]
SET CLOUDCONFIG [ -proxy=<proxyhost>:<port> ] <wallet.zip location>
SET CMDS[EP] {; | c | ON | OFF}
SET CODESCAN [ON | SQLINJECTION | SQLPERFORMANCE | OFF] (For more details, see the description at the bottom.)
SET COLSEP {_ | text}
SET CON[CAT] {. | c | ON | OFF}
SET COPYC[OMMIT] {0 | n}
SET COPYTYPECHECK {ON | OFF}
SET DDL [[ PRETTY | SQLTERMINATOR | CONSTRAINTS | REF_CONSTRAINTS | CONSTRAINTS_AS_ALTER|OID | SIZE_BYTE_KEYWORD | PARTITIONING | SEGMENT_ATTRIBUTES | STORAGE | TABLESPACE | SPECIFICATION | BODY | FORCE | INSERT | |INHERIT | RESET] {on|off} ] | OFF ]
SET DEF[INE] {& | c | ON | OFF}
SET ECHO {ON | OFF}
SET EDITF[ILE] file_name[.ext]
SET EMB[EDDED] {ON | OFF}
SET ENCODING
SET ERRORL[OGGING] {ON | OFF} [TABLE [schema.]tablename] [TRUNCATE] [IDENTIFIER identifier]
SET ESC[APE] {\ | c | ON | OFF}
SET ESCCHAR {@ | ? | % | $ | OFF}
SET EXITC[OMMIT] {ON | OFF}
SET FEED[BACK] {6 | n | ON | OFF} [SQL_ID]
SET FLU[SH] {ON | OFF}
SET HEA[DING] {ON | OFF}
SET HEADS[EP] { | | c | ON | OFF}
SET HISTORY [FAILS [LIMIT [ n | DEFAULT ] ] | NOFAILS |FILTER [DEFAULT <command list>?|<command list>?] |LIMIT [n|DEFAULT]]
SET LDAPCON
SET LIN[ESIZE] {80 | n}
SET LOAD default [options...]
SET LOADFORMAT [ DEFAULT | CSV | DELIMITED | HTML | INSERT | JSON | JSON-FORMATTED | LOADER | T2 | XML ] [options...]
SET LONG {80 | n}
SET LONGC[HUNKSIZE] {80 | n}
SET MAXROWS {n>1 | DEFAULT}
SET MAXSPOOLROWSTRUNCATE [ON | OFF | DEFAULT]
SET NET {ON | OFF | READONLY}
SET NEWP[AGE] {1 | n | NONE}
SET NOVERWRITE {ON | OFF | WARN}
SET NULL text
SET NUMF[ORMAT] format
SET NUM[WIDTH] {10 | n}
SET PAGES[IZE] {14 | n}
SET PARAMETERPOLICY {default | isolate}
SET PAU[SE] {ON | OFF | text}
SET RECSEPCHAR { | c}
SET SERVEROUT[PUT] {ON | OFF} [SIZE {n | UNL[IMITED]}] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]
SET SHOW[MODE] {ON | OFF}
SET SQLBL[ANKLINES] {ON | OFF}
SET SQLC[ASE] {MIX[ED] | LO[WER] | UP[PER]}
SET SQLCO[NTINUE] {> | text}
SET SQLFORMAT {csv | html | xml | json | ansiconsole | insert | loader | fixed | default}
SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
SET SQLPRE[FIX] {# | c}
SET SQLP[ROMPT] {SQL> | text}
SET SUF[FIX] {SQL | text}
SET T2 METRICDATA NAMESPACE {text}
SET T2 METRICDATA COMPARTMENTID {text}
SET T2 METRICDATA NAME {text}
SET T2 DIMENSIONS RESOURCEID {text}
SET T2 DIMENSIONS REGION {text}
SET T2 METADATA UNIT {text}
SET TAB {ON | OFF}
SET TERM[OUT] {ON | OFF}
SET TI[ME] {ON | OFF}
SET TIMI[NG] {ON | OFF}
SET TRIM[OUT] {ON | OFF}
SET TRIMS[POOL] {ON | OFF}
SET VER[IFY] {ON | OFF}
SET WRA[P] {ON | OFF}

SET DDL [[ PRETTY | SQLTERMINATOR | CONSTRAINTS | REF_CONSTRAINTS | CONSTRAINTS_AS_ALTER|OID | SIZE_BYTE_KEYWORD | PARTITIONING | SEGMENT_ATTRIBUTES | STORAGE | TABLESPACE | SPECIFICATION | BODY | FORCE | INSERT | |INHERIT | RESET] {on|off} ] | OFF ]

Allows you to set the DDL transform option on DBMS_METADATA.

SET ENCODING <encoding>

Allows you to set the encoding for the current session. Use SHOW ENCODING to view the encoding set for the current session. Use SHOW ENCODINGS to list the encodings available on your platform.

SET CODESCAN [ON | SQLINJECTION | SQLPERFORMANCE | OFF]

Controls warning messages issued for code quality issues. ON turns on warnings for possible SQL injection vulnerabilities and SQL performance issues. See SQL Performance Troubleshooting