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: Satheesh Babu.S <satheesh.babu_at_iflexsolutions.com>
Date: 17 Sep 2004 05:13:38 -0700
Message-ID: <c8292b82.0409170413.732d6006@posting.google.com> 





select version from v$instance;



Depending on platform, one of the below query will give you the verison. 



select ksmmmval from x$ksmmem where indx = 1;
or


select ksmmmval from x$ksmmem where indx = 2;




Thanks and Regards,


Satheesh Babu.S


Bangalore.
Received on Fri Sep 17 2004 - 07:13:38 CDT












Original text of this message













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