| SHOW |
SHO[W] [var] |
Lists the value of a specific SQL*Plus setting, or of all settings.
SHO[W] ERR[ORS] [type] [[schema.]name]
Displays compilation errors from an attempt to create or replace a stored PL/SQL program unit.
Keywords
var
May be one of the following:
- ALL
- BTI[TLE]
- LABEL (obsolete beginning with Oracle8i )
- LNO
- PARAMETERS
- PNO
- REL[EASE]
- REPF[OOTER]
- REPH[EADER]
- SGA
- SPOO[L]
- SQLCODE
- TTI[TLE]
- USER
In addition to these specific items, you can also use any SQL*Plus system variables that can be used with the SET command.
ERRORS
When specified without an additional keyword, displays the errors for the most recently compiled PL/SQL procedure. When type and name are included, errors are shown for the most recent compilation of that object.
type
May be one of the following:
- FUNCTION
- PROCEDURE
- PACKAGE
- PACKAGE BODY
- TRIGGER
- VIEW
- TYPE
- TYPE BODY
schema
Specifies the name of the schema that contains the named object. If omitted, the current schema is assumed.
name
Specifies the name of the stored object for which errors are to be displayed.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
