查看一下oracle数据库软件已经安装的组件（视图dba_registry）

我们先用如下SQL 查看一下DB中的组件：
SQL> col comp_id for a15
SQL> col version for a15
SQL> col comp_name for a30
SQL> select comp_id,comp_name,versionfrom dba_registry ;

COMP_ID COMP_NAME VERSION
--------------- ---------------------------------------------
XDB Oracle XML Database 11.2.0.3.0
AMD OLAP Catalog 11.2.0.3.0
EM Oracle Enterprise Manager 11.2.0.3.0
SDO Spatial 11.2.0.3.0
ORDIM Oracle Multimedia 11.2.0.3.0
CONTEXT Oracle Text 11.2.0.3.0
ODM Oracle Data Mining 11.2.0.3.0