The Oracle (tm) Users' Co-Operative FAQ

Which Version of the database am I running ?


Author's name: Hemant Parkhi

Author's Email: Hemant.Parkhi@Teknometri.no

Date written: 7th Aug 2001
Updated: 28th Jan 2002

Oracle version(s): 8.1.7

Which version of the database am I running ?

Back to index of questions


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


Back to top

Back to index of questions