Re: Getting Oracle version

From: <michael_bialik_at_my-deja.com>
Date: Tue, 05 Oct 1999 21:24:33 GMT
Message-ID: <7tdqa3$j3r$1@nnrp1.deja.com>

Hi.

It works woth 7.3, 8.0.4 and 8.1.5.
There is no better way ( that I know off ).

Michael.

In article <RiiK3.2608$wA2.200264_at_juliett.dax.net>, "Dag Arne Matre" <dam_at_visma.no> wrote:
> 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?
>
> Thanks,
> D A
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 16:24:33 CDT