sql>col comp_name for a30
sql>col comp_id for a10
sql>col version for a10
sql>select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)
comp_id,substr(version,1,12) version,status from dba_registry;
COMP_NAME COMP_ID VERSION STATUS
------------------------------ ---------- ---------- --------------------------------------------
Oracle Database Catalog Views CATALOG 10.2.0.1.0 VALID
Oracle Database Packages and T CATPROC 10.2.0.1.0 VALID
Oracle Workspace Manager OWM 10.2.0.1.0 VALID
JServer JAVA Virtual Machine JAVAVM 10.2.0.1.0 VALID
Oracle XDK XML 10.2.0.1.0 VALID
Oracle Database Java Packages CATJAVA 10.2.0.1.0 VALID
Oracle Expression Filter EXF 10.2.0.1.0 VALID
Oracle Data Mining ODM 10.2.0.1.0 VALID
Oracle Text CONTEXT 10.2.0.1.0 VALID
Oracle XML Database XDB 10.2.0.1.0 VALID
Oracle Rules Manager RUL 10.2.0.1.0 VALID
Oracle interMedia ORDIM 10.2.0.1.0 VALID
OLAP Analytic Workspace APS 10.2.0.1.0 VALID
Oracle OLAP API XOQ 10.2.0.1.0 VALID
OLAP Catalog AMD 10.2.0.1.0 VALID
Spatial SDO 10.2.0.1.0 VALID
Oracle Enterprise Manager EM 10.2.0.1.0 VALID
17 rows selected.
sql>
阅读(362) | 评论(0) | 转发(0) |