Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Oracle version

Re: Getting Oracle version

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 5 Oct 1999 10:22:23 +0200
Message-ID: <7tcchh$34a$1@oceanite.cybercable.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US