SYS@capgent1> column OWNER format a15; SYS@capgent1> column OBJECT_NAME format a20; SYS@capgent1> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED from dba_objects where object_name='DUAL'; OWNER OBJECT_NAME OBJECT_TYPE CREATED --------------- -------------------- ------------------- --------- SYS DUAL TABLE 12-MAR-08 PUBLIC DUAL SYNONYM 12-MAR-08 SYS@capgent1> SYS@capgent1> col COMP_NAME format a40 SYS@capgent1> col STATUS format a7 SYS@capgent1> col COMP_ID format a8 SYS@capgent1> col VERSION format a10 SYS@capgent1> SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY; COMP_ID COMP_NAME VERSION STATUS -------- ---------------------------------------- ---------- ------- CATALOG Oracle Database Catalog Views 10.2.0.4.0 VALID CATPROC Oracle Database Packages and Types 10.2.0.4.0 VALID OWM Oracle Workspace Manager 10.2.0.4.3 VALID JAVAVM JServer JAVA Virtual Machine 10.2.0.4.0 VALID XML Oracle XDK 10.2.0.4.0 VALID CATJAVA Oracle Database Java Packages 10.2.0.4.0 VALID EXF Oracle Expression Filter 10.2.0.4.0 VALID ODM Oracle Data Mining 10.2.0.4.0 VALID CONTEXT Oracle Text 10.2.0.4.0 VALID XDB Oracle XML Database 10.2.0.4.0 VALID RUL Oracle Rules Manager 10.2.0.4.0 VALID COMP_ID COMP_NAME VERSION STATUS -------- ---------------------------------------- ---------- ------- ORDIM Oracle interMedia 10.2.0.4.0 VALID APS OLAP Analytic Workspace 10.2.0.4.0 INVALID XOQ Oracle OLAP API 10.2.0.4.0 INVALID AMD OLAP Catalog 10.2.0.4.0 INVALID SDO Spatial 10.2.0.4.0 VALID EM Oracle Enterprise Manager 10.2.0.4.0 VALID RAC Oracle Real Application Clusters 10.2.0.4.0 VALID 18 rows selected. SYS@capgent1> SYS@capgent1> spool off