To view the different options installed in the database, you should use DBA_REGISTRY, as follows:
set lines 200 pages 100
col comp_name format a40
SELECT COMP_NAME,COMP_ID,VERSION,STATUS FROM DBA_REGISTRY;
Example output:
SQL> SELECT COMP_NAME,COMP_ID,VERSION,STATUS FROM DBA_REGISTRY;
COMP_NAME COMP_ID VERSION STATUS
---------------------------------------- ------------------------------ ------------------------------ --------------------------------------------
Oracle Text CONTEXT 11.2.0.4.0 VALID
Oracle Application Express APEX 3.2.1.00.12 VALID
Oracle Multimedia ORDIM 11.2.0.4.0 VALID
Oracle XML Database XDB 11.2.0.4.0 VALID
Oracle Expression Filter EXF 11.2.0.4.0 VALID
Oracle Rules Manager RUL 11.2.0.4.0 VALID
Oracle Workspace Manager OWM 11.2.0.4.0 VALID
Oracle Database Catalog Views CATALOG 11.2.0.4.0 VALID
Oracle Database Packages and Types CATPROC 11.2.0.4.0 VALID
JServer JAVA Virtual Machine JAVAVM 11.2.0.4.0 VALID
Oracle XDK XML 11.2.0.4.0 VALID
Oracle Database Java Packages CATJAVA 11.2.0.4.0 VALID
12 rows selected.
No comments:
Post a Comment