Common SQL*Plus Environment Variables
Variable Function Usage
ARRAY[SIZE] Determines the number of rows fetched from database at one time SET ARRAY 50
AUTO[COMMIT] Specifies whether commits of transactions are automatic or manual SET AUTO ON
COLSEP Specifies the text that you want printed in between column values SET COLSEP
COPY[COMMIT] Sets the frequency of commits when using the COPY command SET COPY 10000
DEF[INE]{&/C/ON/OFF} Sets the prefix character used during variable substitutions SET DEFINE ON
ECHO {OFF/ON} Specifies whether echo is on or off SET ECHO ON
EDITF[ILE] Sets the default filename when you use your default editor SET EDITFILE draft.sql
FEED[BACK] {OFF/ON} Specifies whether SQL*Plus shows the number of records returned SET FEEDBACK OFF
FLUSH {OFF/ON} Determines whether output is buffered or flushed to the screen SET FLUSH OFF
HEA[DING] {OFF/ON} Specifies whether the column headers are printed or not SET HEAD OFF
LIN[ESIZE] {80|n} Specifies the number of characters displayed per line SET LINESIZE 40
LONG {80/n} Specifies the maximum width of the LONG, CLOB, NCLOB, and XMLType values SET LONG 100000
NEWP[AGE] {1/n/none} Specifies the number of blank lines at the top of each new page SET NEWPAGE 0
NUM[WIDTH] {10/n} Specifies the format for displaying numbers SET NUM
PAGES[IZE] {24/n} Specifies the number of lines in each page SET PAGESIZE 60
PAU[SE] {OFF/ON/TEXT} Specifies the amount of output that is printed to the screen SET PAUSE ON
SERVEROUT[PUT] {OFF/ON}[SIZE n] Specifies whether output of PL/SQL code is shown SET SERVEROUTPUT ON
SQLP[ROMPT] {SQL> |TEXT} Specifies the command prompt for SQL*Plus sessions SET SQLPROMPT 'salapati >'
TERM[OUT] {OFF/ON} Specifies whether command file output is displayed or not SET TERMOUT OFF
TI[ME] {OFF/ON} Displays time if set to on SET TIME OFF
TIMI[NG] {OFF/ON} Controls the display of timing for SQL commands SET TIMING OFF
VER[IFY] {OFF/ON} Specifies whether SQL text is displayed after variable substitution SET VERIFY OFF
Related examples in the same category