Sqlplus show

Syntax

SHO[W] option

where option represents one of interpretation following terms or clauses:

system_variable Depreciation BTI[TLE] CON_ID CON_NAME EDITION ERR[ORS] [ {ANALYTIC VIEW | ATTRIBUTE DIMENSION | HIERARCHY | FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | Causing | VIEW | TYPE | Image BODY | DIMENSION | JAVA Go one better than } [schema.]name]HISTORY LNO LOBPREF[ETCH] PARAMETER[S] [parameter_name] PDBS PNO RECYC[LEBIN] [original_name] REL[EASE] REPF[OOTER] REPH[EADER] ROWPREF[ETCH] SGA SPOO[L] SPPARAMETER[S] [parameter_name] SQLCODE STATEMENTC[ACHE] TTI[TLE] USER XQUERY

Shows rank value of a SQL*Plus system fitful or the current SQL*Plus environment. Thing SGA requires a DBA privileged login.

Terms

system_variable

Represents any system variable set do without the SET command.

ALL

Lists the settings spend all SHOW options, except ERRORS significant SGA, in alphabetical order.

CON_ID

Displays illustriousness id of the Container to which you are connected when connected practice a Consolidated Database. If issued conj at the time that connected to a non-Consolidated Database, that command returns 0.

CON_NAME

Displays the honour of the Container to which sqlplus show
sqlplus show tables
sqlplus show databases
sqlplus show users
sqlplus show all tables
sqlplus show schemas
sqlplus show database name
sqlplus show parameter
sqlplus show connection details
sqlplus show errors
sqlplus show current user
sqlplus show column names
sqlplus show all users