SHOW

Shows the value of a SQL*Plus system variable or the current SQL*Plus environment.

Syntax

SHO[W] option

where option represents one of the following terms or clauses:

system_variable
ALL
BTI[TLE]
ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY|
   TRIGGER|VIEW} [schema.]name]
LABEL
LNO
PNO
REL[EASE]
REPF[OOTER]
REPH[EADER]
SPOO[L]
SQLCODE
TTI[TLE]
USER

Terms and Clauses

Refer to the following list for a description of each term or clause:

system_variable	Represents any system variable set by the SET command.
ALL	Lists the settings of all SHOW options, except ERRORS and LABEL, in alphabetical order.
BTI[TLE]	Shows the current BTITLE definition.
ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY|TRIGGER|VIEW} [schema.]name]	Shows the compilation errors of a stored procedure (includes stored functions, procedures, and packages). After you use the CREATE command to create a stored procedure, a message is displayed if the stored procedure has any compilation errors. To see the errors, you use SHOW ERRORS.
	When you specify SHOW ERRORS with no arguments, SQL*Plus shows compilation errors for the most recently created or altered stored procedure. When you specify the type (function, procedure, package, package body, trigger, or view) and the name of the PL/SQL stored procedure, SQL*Plus shows errors for that stored procedure. For more information on compilation errors, see your PL/SQL User's Guide and Reference.
	schema contains the named object. If you omit schema, SHOW ERRORS assumes the object is located in your current schema.

Note: You must have DBA privilege to view other schemas, or other schema's object errors.

	SHOW ERRORS output displays the line and column number of the error (LINE/COL) as well as the error itself (ERROR). LINE/COL and ERROR have default widths of 8 and 65, respectively. You can alter these widths using the COLUMN command.
LABEL	Shows the security level for the current session. For more information, see your Trusted Oracle Administrator's Guide.
LNO	Shows the current line number (the position in the current page of the display and/or spooled output).
PNO	Shows the current page number.
REL[EASE]	Shows the release number of Oracle that SQL*Plus is accessing.
REPF[OOTER]	Shows the current REPFOOTER definition.
REPH[EADER]	Shows the current REPHEADER definition.
SPOO[L]	Shows whether output is being spooled.
SQLCODE	Shows the value of SQL.SQLCODE (the SQL return code of the most recent operation).
TTI[TLE]	Shows the current TTITLE definition.
USER	Shows the username under which you are currently accessing SQL*Plus.

Example

To list the current LINESIZE, enter

SQL> SHOW LINESIZE

If the current linesize equals 80 characters, SQL*Plus will give the following response:

linesize 80

The following example illustrates how to create a stored procedure and then show its compilation errors:

SQL> connect system/manager
SQL> create procedure scott.proc1 as
SQL> begin
SQL>   :p1 := 1;
SQL> end;
SQL> /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE SCOTT.PROC1:

LINE/COL ERROR
--------------------------------------------------------
3/3      PLS-00049: bad bind variable 'P1'

SQL> show errors procedure proc1
No errors.
SQL> show errors procedure scott.proc1
Errors for PROCEDURE SCOTT.PROC1:

LINE/COL ERROR
--------------------------------------------------------
3/3      PLS-00049: bad bind variable 'P1'