Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

SHOW

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
       PARAMETER[S] [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 provides ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

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

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

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata