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.