본문 바로가기

Computer Engineering/DB

오라클 show 명령어

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
 
Contact UsLegal Notices and Terms of UsePrivacy Statement


출처 : http://www.psoug.org/reference/show.html