Oracle SHOW
Version 11.2.0.3
 
ALL
Display SQL*Plus configuration parameters SHOW ALL
conn uwclass/uwclass

show all
 
AUTORECOVERY
Display whether AUTORECOVERY is enabled SHOW AUTORECOVERY
show autorecover
 
EDITION
Display the name of the current session edition SHOW EDITION
show edition
 
ERRORS
Display information about the most recent PL/SQL compilation error SHOW ERRORS
conn uwclass/uwclass

CREATE PROCEDURE p IS
BEGIN
  bad_code;
END;
/

show errors
 
INSTANCE
Display the connect identifier for the default instance SHOW INSTANCE
conn / as sysdba

show instance
 
LOGSOURCE
Display the location for archive logs SHOW LOGSOURCE
conn / as sysdba

show logsource
 
PARAMETERS
Display the initialization parameters SHOW PARAMETERS <parameter_name>
conn / as sysdba

set linesize 121

show parameter undo
 
RECYCLEBIN
Display the objects in the recyclebin that can be reverted with FLASHBACK SHOW RECYCLEBIN
conn uwclass/uwclass

show recyclebin

CREATE TABLE t (
testcol VARCHAR2(20));

DROP TABLE t;

show recyclebin
 
RELEASE
Display the Oracle release number SHOW RELEASE
conn uwclass/uwclass

show release
 
SGA
Display information about the SGA SHOW SGA
conn / as sysdba

show sga
 
SQLCODE
Display the value of the SQLCODE environment variable SHOW SQLCODE
conn uwclass/uwclass

drop tabel zzyzx;

show sqlcode
 
USER
Display the current user information SHOW USER
conn uwclass/uwclass

show user
 
XQUERY
Displays the current values of the XQUERY settings, BASEURI, CONTEXT, NODE and ORDERING SHOW XQUERY
conn uwclass/uwclass

show xquery
 
Related Topics
SQL*Plus
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved