Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Oracle version
Yes, this works both in Oracle7 and Oracle8.
With SQL*Plus you can use the define variable _O_RELEASE:
DEFINE _O_RELEASE = "703040100" (CHAR) DEFINE _O_RELEASE = "800050000" (CHAR)
--
Regards
Michel
Dag Arne Matre <dam_at_visma.no> a écrit dans le message :
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 - 03:22:23 CDT