Name
SHOW
Synopsis
SHO[W] [ | setting |
ALL | BTI[TLE] |
ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE |
PACKAGE BODY | TRIGGER | TYPE |
TYPE BODY | VIEW}
[owner.]object_name] |
LNO | PARAMETER[S] [parameter_name] |
PNO | REL[EASE] | REPF[OOTER] |
REPH[EADER] |
SGA | SPOO[L] | SQLCODE | TTI[TLE] |
USER]The SHOW command allows you to look at the current state of your SQL*Plus environment. For example:
SHOW PARAMETER db_block_buffers SHOW LINESIZE SHOW TTITLE
Parameters
- setting
Is any one of the settings you can set using the SET command.
- ALL
Shows everything, except for errors and the System Global Area (SGA).
- BTI[TLE]
Displays the current page footer.
- ERR[ORS]
Displays an error listing for a stored object. The command SHOW ERRORS by itself causes the error listing for the most recently created object to be displayed. You can get the error listing for a specific object by specifying the object type (function, procedure, and so forth) and the object name.
- FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | TYPE | TYPE BODY | VIEW
Used with SHOW ERRORS to specify the object type of interest.
- [owner.] object_name
Used with SHOW ERRORS to name the object for which you want to display an error listing.
- LNO
Displays the current line number.
- PARAMETER[S] [ parameter_name ]
Displays the current value of one or more database initialization parameters.
- PNO
Displays the current page number.
- REL[EASE]
Displays the release number (the version) of the Oracle database to which you are connected.
- REPF[OOTER]
Displays the current report footer.
- REPH[EADER]
Displays the current report header.
- SGA
Displays information about the current state of the System Global Area.
- SPOO[L]
Tells you whether output is currently being spooled to a file.
- SQLCODE
Displays the SQL code returned by the most recent SQL statement.
- TTI[TLE]
Displays the current page title.
- USER
Displays the current username.