Which version of the database server am I running ?

The Oracle (tm) Users' Co-Operative FAQ

Which Version of the database am I running ?

When you connect to sql plus, you can see the version of Oracle Database you are connecting to. This is it.

If you are not connecting through SQL*Plus, then look at v$version:

	select * from v$version;
	BANNER
	----------------------------------------------------------------
	Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
	PL/SQL Release 8.1.7.2.0 - Production
	CORE    8.1.7.0.0       Production
	TNS for IBM/AIX RISC System/6000: Version 8.1.7.2.0 - Production
	NLSRTL Version 3.4.1.0.0 - Production

Addendum (28th Jan 2002)

Wayne.Mills@rossnutrition.com also offers this option:

	select version from v$instance
	VERSION
	------------
	8.1.7.0.0

Further reading: N/A