2.9.7 SHOW option

Shows the value of a SQLcl system variable, or the current SQLcl environment. Enter any system variable set by the SET command in place of system_variable. SHOW SGA can only be used by a DBA user. Use one of the following terms or clauses in place of option:

• system_variable
• ALL
• BTI[TLE]
• CON_ID
• CON_NAME
• CONNECTION
• DDL
• EDITION
• ENCODING
• ENCODINGS
• ERR[ORS] [ {FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
• INSTANCE
• JAVA
• JDBC
• LNO
• NLS
• PARAMETER[S] [parameter_name]
• PDBS
• PNO
• RECYC[LEBIN] [original_name]
• REL[EASE]
• REPF[OOTER]
• REPH[EADER]
• SGA
• SPOO[L]
• SPPARAMETER[S] [parameter_name]
• SQLCODE
• SQLPATH
• TNS
• TTI[TLE]
• USER
• VERSION

SHOW ENCODING

Shows the encoding which is set for the client.

SHOW ENCODINGS

Shows the available encodings for the client.