Re: Reading Release Number

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 01 Oct 1998 19:25:01 GMT
Message-ID: <3629d660.114033000@192.86.155.100>

A copy of this was sent to NBronke_at_t-online.de (Nicolas Bronke) (if that email address didn't require changing) On 1 Oct 1998 16:10:42 GMT, you wrote:

>Does exist a possibility to read the current oracle release (other than
>using V$Version)?
>
>Regards
>Nicolas
>

Do you mean is it in another table? (and if so, why isn't v$version good enough?)

You could call the procedure in dbms_utility:

  PROCEDURE db_version(version       OUT VARCHAR2,
                       compatibility OUT VARCHAR2);
  -- Return version information for the database:
  -- version -> A string which represents the internal software version
  --            of the database (e.g., 7.1.0.0.0). The length of this string
  --            is variable and is determined by the database version.
  -- compatibility -> The compatibility setting of the database determined by
  --                  the "compatible" init.ora parameter. If the parameter
  --

If you are 'outside' the database, you could read the file $ORACLE_HOME/orainst/unix.rgs ($ORACLE_HOME\orainst\nt.rgs on NT)...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 01 1998 - 14:25:01 CDT