| 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 |
