Synopsis

SHO[W] variable

Lists the current value of one of the following SQL*Plus system variables. In addition, note that any value that can be SET may also be used as a variable.

ALL 
APPI[NFO] 
BTI[TLE] 
ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | 
    TYPE | TYPE BODY} [schema.] name] 
LABEL 
LNO 
PNO 
REL[EASE] 
REPF[OOTER] 
REPH[EADER] 
SPOO[L] 
SQLCODE 
TTI[TLE] 
USER