O'Reilly logo

Oracle SQL*Plus: The Definitive Guide, 2nd Edition by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

SHOW

Synopsis

The SHOW command looks at the state of your SQL*Plus environment. You can use it to display the current value of any setting controlled by the SET command. (TRUNCATE is the one exception.) SHOW can look at page titles, page footers, etc.

Syntax

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}

Parameters

SHO[W]

Is the command, which may be abbreviated SHO.

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 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 necessary only 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

Displays the current line number.

PARAMETER[S] [parameter_name]

Displays the current value of one or more initialization ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required