I'm searching for a reliable way to get the version number
of an Oracle server.
I collected some alternatives:

 select * from v$version;

 select * from PRODUCT_COMPONENT_VERSION;

 set serveroutput on
 declare
   v varchar2(255);
   c varchar2(255);
 begin
   dbms_utility.db_version( v, c );
   dbms_output.put_line( v );
   dbms_output.put_line( c );
 end;
 /

 select dbms_utility.port_string from dual;

For Oracle8 results, see e.g.:

  <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2002-01/msg00525.html>

Unfortunately, I have no Oracle7 available. Would somebody
be kind enough to provide the results for an Oracle7 server?

Many thanks in advance,
Steffen Goeldner

Reply via email to