Parameters
- setting
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 | DIMENSION | JAVA CLASS
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.