Search notes:

SQLcl: SET

SET sets a system variable to a value:

SQL> set var value

The following table lists available system variables. The colum SQL*Plus indicates if the variable is available in SQL*Plus:

Variable	SQL*Plus
`appinfo`
`arraysize`
`autocommit`
`autoprint`
`autorecovery`
`autotrace`
`blockterminator`
`classic`	✗
`clear`	✗
`cloudconfig`	✗
`cmdsep`
`codescan`	✗
`colinvisible`
`colsep`
`concat`
`copycommit`
`copytypecheck`
`datapump`	✗
`datapumpexamples`	✗
`datapumpsyntax`	✗
`define`
`echo`	✗
`editfile`
`editor`	✗
`embedded`
`encoding`	✗
`errorlogging`
`escape`		Escape character.
`escchar`		Also escape character.
`exitcommit`
`feedback`
`flush`
`heading`
`headsep`
`highligthing`	x	Highlight comments, keywords, identifiers etc with different colors, underlines or boldness etc.
`history`
`ldapcon`	✗
`linesize`
`load`	✗
`loadformat`	✗
`long`
`longchunksize`
`maxrows`	✗
`maxspoolrowstruncate`	✗
`net`	✗
`newpage`
`noverwrite`	✗
`null`
`numformat`
`numwidth`
`pagesize`
`parameterpolicy`	✗	See also the `argument` command
`pause`
`recsepchar`
`secureliterals`	✗
`serveroutput`
`showmode`
`socksproxy`	✗
`sqlblanklines`
`sqlcase`	✗
`sqlcontinue`
`sqlformat`	✗
`sqlpluscompatibility`
`sqlprefix`
`sqlprompt`
`sqlterminator`
`statusbar`	✗
`suffix`
`t2`	✗
`tab`
`termout`
`time`
`timing`
`trimout`
`trimspool`
`verify`
`wallet`	✗
`wrap`
`xquery`