Oracle SQL*Plus Pocket Reference

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 ...