CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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

show all
 
AUTORECOVERY
Display whether AUTORECOVERY is enabled SHOW AUTORECOVERY
show autorecover
 
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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [63 users online]    © 2010 psoug.org