Re: Release detecting

Wolf Grossi <wg_at_REMOVE_ANTI_SPAMmagro-soft.com> wrote in message news:37a1fe13.0_at_195.70.96.56...
> Hi,
> ist there an appropriate methode to find out what oracle version is
> installed on a UNIX box?
> I have a complex OCI-application and need to relink it on serveral UNIX's
> with ORA6 (yes...) 7 and 8, using one script to detect the ora version by
> looking for, in my opinion release-specific, files; but this is not very
> reliable.
> Thanks for hints, Wolf

To find out the version of each component:

    select banner from v$version;

or

    select * from product_component_version;

To fine out the version of Oracle server:

    select version from v$instance; Received on Mon Aug 02 1999 - 12:58:40 CDT