SET sets a system variable to a value: SQL> set var value
| 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 | ✗ | Sets the character encoding for the current session. |
encodings | ✗ | |
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 |