	--查询数据库已经安装组件

	SQL> col COMP_NAME for a35

	SQL> select comp_name, version, status from dba_registry;

	COMP_NAME                           VERSION                        STATUS

	----------------------------------- ------------------------------ ----------------------

	Oracle Database Catalog Views       10.2.0.1.0                     VALID

	Oracle Database Packages and Types  10.2.0.1.0                     VALID

	Oracle Workspace Manager            10.2.0.1.0                     VALID

	JServer JAVA Virtual Machine        10.2.0.1.0                     VALID

	Oracle XDK                          10.2.0.1.0                     VALID

	Oracle Database Java Packages       10.2.0.1.0                     VALID

	Oracle Expression Filter            10.2.0.1.0                     VALID

	Oracle Data Mining                  10.2.0.1.0                     VALID

	Oracle Text                         10.2.0.1.0                     VALID

	Oracle XML Database                 10.2.0.1.0                     VALID

	Oracle Rules Manager                10.2.0.1.0                     VALID

	Oracle interMedia                   10.2.0.1.0                     VALID

	OLAP Analytic Workspace             10.2.0.1.0                     VALID

	Oracle OLAP API                     10.2.0.1.0                     VALID

	OLAP Catalog                        10.2.0.1.0                     VALID

	Spatial                             10.2.0.1.0                     VALID

	Oracle Enterprise Manager           10.2.0.1.0                     VALID

ITPub博客

查询数据库已经安装组件