Re: Getting Oracle version

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 8 Oct 1999 16:56:56 GMT
Message-ID: <7tl7oo$n28$6@news.seed.net.tw>

Dag Arne Matre <dam_at_visma.no> wrote in message news:RiiK3.2608$wA2.200264_at_juliett.dax.net...
> I need to find the version number of the Oracle server. I have this SQL:
> select banner from v$version where substr(banner,1,6) = 'Oracle'
>
> Does this work with all Oracle7 and 8 versions?
> Is there a better way?

There are many to get version number, for example,

SQL> select version from v$instance;

VERSION

---

8.0.4.0.0

SQL> select version from product_component_version   2 where product like 'Oracle%';

VERSION

---

8.0.4.0.0 Received on Fri Oct 08 1999 - 11:56:56 CDT