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: Oracle version via SQL

Re: Oracle version via SQL

From: giancarlo capossela <gcapossela_at_icare.it>
Date: Wed, 30 Jun 1999 23:08:45 +0200
Message-ID: <377A875D.C595CAFB@icare.it>


you can try this statement:

select banner from v$version

Giancarlo Capossela
gcapossela_at_icare.it

EG ha scritto:

> Actually the subject says it all, but to rephrase it:
>
> Is there a way to identify the version of the Oracle DBMS
> via SQL? I am looking for a way to get that data from a
> PL/SQL block.
>
> Thanks in advance,
>
> Eric
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****
Received on Wed Jun 30 1999 - 16:08:45 CDT

Original text of this message

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