Here's the output from Oracle 7.3.4.. This is on a Solaris 8 box..
dbms_utility.db_version does not appear to exist on Oracle7.. -Adam [oracle@mastiff /oracle]$ sqlplus sys/password SQL*Plus: Release 3.3.4.0.1 - Production on Fri Jan 25 17:25:00 2002 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. Connected to: Oracle7 Server Release 7.3.4.3.0 - Production With the distributed, replication and parallel query options PL/SQL Release 2.3.4.3.0 - Production SQL> @test SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle7 Server Release 7.3.4.3.0 - Production PL/SQL Release 2.3.4.3.0 - Production CORE Version 3.5.4.0.0 - Production TNS for Solaris: Version 2.3.4.0.0 - Production NLSRTL Version 3.2.4.0.0 - Production SQL> SQL> select * from PRODUCT_COMPONENT_VERSION; PRODUCT ---------------------------------------------------------------- VERSION ---------------------------------------------------------------- STATUS ---------------------------------------------------------------- CORE 3.5.4.0.0 Production NLSRTL 3.2.4.0.0 Production PRODUCT ---------------------------------------------------------------- VERSION ---------------------------------------------------------------- STATUS ---------------------------------------------------------------- Oracle7 Server 7.3.4.3.0 Production PL/SQL 2.3.4.3.0 PRODUCT ---------------------------------------------------------------- VERSION ---------------------------------------------------------------- STATUS ---------------------------------------------------------------- Production TNS for Solaris: 2.3.4.0.0 Production SQL> SQL> rem set serveroutput on; SQL> rem declare SQL> rem v varchar2(255); SQL> rem c varchar2(255); SQL> rem begin SQL> rem dbms_utility.db_version( v, c ); SQL> rem dbms_output.put_line( v ); SQL> rem dbms_output.put_line( c ); SQL> rem end; SQL> rem / SQL> SQL> select dbms_utility.port_string from dual; PORT_STRING -------------------------------------------------------------------------------- SVR4-be-7.0.0 On Thu, 2002-01-24 at 09:51, Steffen Goeldner wrote: > 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 > -- [EMAIL PROTECTED] http://www.oracletool.com
