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: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 8 Mar 2005 09:03:38 -0800
Message-ID: <1110301418.109527.235470@o13g2000cwo.googlegroups.com> 






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
Received on Tue Mar 08 2005 - 11:03:38 CST












Original text of this message













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