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
I received results for Oracle7 from Volker I. Lipper (see attachment).
Many thanks Volker!
Steffen
SQLWKS> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Workgroup Server Release 7.3.4.0.0 - Production
PL/SQL Release 2.3.4.0.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 - Production
5 rows selected.
SQLWKS> select * from PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION
STATUS
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
CORE 3.5.4.0.0
Production
NLSRTL 3.2.4.0.0
Production
Oracle7 Workgroup Server 7.3.4.0.0
Production
PL/SQL 2.3.4.0.0
Production
TNS for 32-bit Windows: 2.3.4.0.0
Production
5 rows selected.
SQLWKS> set serveroutput on
Server Output ON
SQLWKS> declare
2> v varchar2(255);
3> c varchar2(255);
4> begin
5> dbms_utility.db_version( v, c );
6> dbms_output.put_line( v );
7> dbms_output.put_line( c );
8> end;
9>
dbms_utility.db_version( v, c );
*
ORA-06550: Zeile 5, Spalte 18:
PLS-00302: Komponente 'DB_VERSION' muß deklariert werden
ORA-06550: Zeile 5, Spalte 5:
