Re: determining Oracle version and locating

Hi,

on NT look at the registry: HKEY_LOCAL_MACHINE\Software\Oracle on UNIX check enviroments variables ORACLE_HOME, ORACLE_SID

To check version query:
SELECT * FROM v$version;

ciao torsten

Christoph Kukulies wrote:

> I need a safe way to determine whether at all Oracle is installed on a
> machine and if, which version and where it is located. Also I need
> to know what the OCI client lib is (OCICLIENT8.DLL for example).
>
> (Please Cc: me).
>
> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de

--
=================================
Torsten Wiederkehr
SoftGroup GmbH
Dürkheimer Str. 130
D-67227 Frankenthal
Tel: +49 (0)6233 519-912
Fax: +49 (0)6233 519-913
Mobil: +49 (0)160 478 08 28
E-mail: twiederkehr_at_softgroup.de
=================================