Re: Getting Oracle version

From: james f. koopmann <jkoopmann_at_servman.com>
Date: Tue, 5 Oct 1999 08:11:05 -0600
Message-ID: <rvk1rsh6rad77@corp.supernews.com>

you might be more interested in the compaibility is set to : SELECT value FROM v$parameter WHERE name = 'compatible'

james f. koopmann
www.servman.com

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?
>
> Thanks,
> D A
>
>
Received on Tue Oct 05 1999 - 09:11:05 CDT