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 -> Getting Oracle version

Getting Oracle version

From: Dag Arne Matre <dam_at_visma.no>
Date: Tue, 05 Oct 1999 08:05:05 GMT
Message-ID: <RiiK3.2608$wA2.200264@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:05:05 CDT












Original text of this message













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