| 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 ? | |
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
Wayne.Mills@rossnutrition.com also offers this option:
select version from v$instance VERSION ------------ 8.1.7.0.0
Further reading: N/A