The SHOW command allows you to look at the current state of your SQL*Plus environment. You can use it to display the current value of any setting controlled by the SET command. SHOW may also be used to look at current page titles, page footers, and so forth.
SHO[W]settingALL 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
where:
- SHO[W]
Is the command, which may be abbreviated to SHO.
- setting
Is any one of the settings you can set using the SET command.
- ALL
- BTI[TLE]
- 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. This is only necessary if you are specifying the name of the object.
- [owner.]object_name
Used with SHOW ERRORS to name the object for which you want to display an error listing.
- LNO
- PARAMETER[S] [parameter_name]
Displays the current value of one or more initialization parameters. Chapter 10 provides detailed examples of SHOW PARAMETERS in use.
- PNO
- REL[EASE]
Displays the release number (the version) of the Oracle database to which you are connected.
- REPF[OOTER]
- REPH[EADER]
- SGA
Displays information about the current state of the System Global Area. See Chapter 10 for more information about this option.
- SPOO[L]
Tells you whether or not output is currently being spooled to a file.
- SQLCODE
Displays the SQL code returned by the most recent SQL statement.
- TTI[TLE]
- USER