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

Home -> Community -> Usenet -> c.d.o.misc -> Re: checking Oracle version

Re: checking Oracle version

From: Jarek <jarek_at_krak.pl>
Date: Wed, 09 Mar 2005 10:02:24 +0100
Message-ID: <d0me42$9cj$1@atlantis.news.tpi.pl>


Użytkownik Rauf Sarwar napisał:
> Jarek wrote:
>

>>How can I check Oracle version?
>>If I execute procedure with 'select version from v$instance' I get

>
> error
>
>>that 'table or view not exists' because I'm not SYS user. Is any way

>
> to
>
>>check it?
>>
>>Thanks,
>>Jarek

>
>
> You can use,
> dbms_utility.db_version(version => :version,
> compatibility => :compatibility)
>
> Regards
> /Rauf
>

It works.
Thanks a lot. Received on Wed Mar 09 2005 - 03:02:24 CST

Original text of this message

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