Find XDK version [message #138054] |
Mon, 19 September 2005 11:40 |
mpinvitesu
Messages: 15 Registered: July 2005
|
Junior Member |
|
|
Hi,
This is a quick question. Where can I find information regarding te installed packages in oracle. I am actually trying to find what version of XDK is installed in oracle. Is there any table which I can query to find the details of all installed packages??
|
|
|
Re: Find XDK version [message #144298 is a reply to message #138054] |
Tue, 25 October 2005 17:31 |
mchadder
Messages: 224 Registered: May 2005 Location: UK
|
Senior Member |
|
|
The current version of the XDK can be obtained by querying DBA_REGISTRY, i.e.
SQL> col comp_id format a10
SQL> col comp_name format a40
SQL> col version format a10
SQL> SELECT comp_id, comp_name, version
2 FROM dba_registry
3 /
COMP_ID COMP_NAME VERSION
---------- ---------------------------------------- ----------
CATALOG Oracle Database Catalog Views 10.2.0.1.0
CATPROC Oracle Database Packages and Types 10.2.0.1.0
OWM Oracle Workspace Manager 10.2.0.1.0
JAVAVM JServer JAVA Virtual Machine 10.2.0.1.0
XML Oracle XDK 10.2.0.1.0
CATJAVA Oracle Database Java Packages 10.2.0.1.0
EXF Oracle Expression Filter 10.2.0.1.0
ODM Oracle Data Mining 10.2.0.1.0
CONTEXT Oracle Text 10.2.0.1.0
XDB Oracle XML Database 10.2.0.1.0
RUL Oracle Rules Manager 10.2.0.1.0
ORDIM Oracle interMedia 10.2.0.1.0
APS OLAP Analytic Workspace 10.2.0.1.0
XOQ Oracle OLAP API 10.2.0.1.0
AMD OLAP Catalog 10.2.0.1.0
SDO Spatial 10.2.0.1.0
EM Oracle Enterprise Manager 10.2.0.1.0
17 rows selected.
Regards
|
|
|