set pagesize 40
column componentName format a40 heading 'Component Name'
column version format a15 heading 'Version'
column status format a8 heading 'Status'
select COMP_NAME componentName,
VERSION version,
STATUS status
from dba_registry;
Example:
Component Name Version Status
---------------------------------------- --------------- --------
OWB 11.1.0.6.0 VALID
Oracle Application Express 3.0.1.00.08 VALID
Oracle Enterprise Manager 11.1.0.6.0 VALID
Oracle Ultra Search 11.1.0.6.0 VALID
OLAP Catalog 11.1.0.6.0 VALID
Spatial 11.1.0.6.0 VALID
Oracle Multimedia 11.1.0.6.0 VALID
Oracle XML Database 11.1.0.6.0 VALID
Oracle Text 11.1.0.6.0 VALID
Oracle Expression Filter 11.1.0.6.0 VALID
Oracle Rules Manager 11.1.0.6.0 VALID
Oracle Workspace Manager 11.1.0.6.0 VALID
Oracle Database Catalog Views 11.1.0.6.0 VALID
Oracle Database Packages and Types 11.1.0.6.0 VALID
JServer JAVA Virtual Machine 11.1.0.6.0 VALID
Oracle XDK 11.1.0.6.0 VALID
Oracle Database Java Packages 11.1.0.6.0 VALID
OLAP Analytic Workspace 11.1.0.6.0 VALID
Oracle OLAP API 11.1.0.6.0 VALID
