Oracle SQL Plus Pocket Reference, 2nd Edition

Name

SHOW

Synopsis

SHO[W] [setting |
   ALL | BTI[TLE] |
   ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE |
              PACKAGE BODY | TRIGGER | TYPE |
              TYPE BODY | DIMENSION | JAVA CLASS}
            [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

Any one of the settings controlled with 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. ...