Re: Locating Oracle Versions

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Thu, 30 Jul 1998 12:48:10 -0600
Message-ID: <35c0bf7a.0@news.cadvision.com>

The best way is to connect and look in the v$version table. It lists the major components.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
See you at the Powersoft Conference in L.A. http://www.sybase.com/Events/psuc98/index.html

Kevin Seneviratne wrote in message <35C01D86.539F04EA_at_connect.com.au>...
>Hi All,
>
>I need to figure out the exact version of the Oracle Server prior to
establishing a connection.
>
>A quick look shows $ORACLE_HOME/orainst/RELVER seems to have
>what I want, at least on Solaris w/ 7.3.2 and 8.0.4.
>
>Will this work in most cases ?
>
>Is there a smarter more reliable way to do this ?
>
>Things like
>SELECT * FROM product_component_version;
>are no use as I want the info prior to connection.
>
>Many thanks in advance
>
>Kevin Seneviratne
Received on Thu Jul 30 1998 - 13:48:10 CDT