O'Reilly logo

Oracle SQL*Plus: The Definitive Guide 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

The SHOW Command

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] setting
       ALL
       BTI[TLE]
       ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY|
                  TRIGGER|TYPE|TYPE BODY|VIEW} [owner.]object_name]
       LNO
       PARAMETERS [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

Shows everything, except for errors and the 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. 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

Displays the current line number.

PARAMETER[S] [parameter_name]

Displays the current value of one or more initialization parameters. Chapter 10

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