How to view Oracle database versions

Method One: V$version

Sql> select * from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition release 11.1.0.7.0-64bit Production
pl/sql release 11.1.0.7.0-production
CORE    11.1 .0.7.0      Production
TNS for linux:version 11.1.0.7.0-production
Nlsrtl Version 11.1.0.7.0-production

Method Two: Product_component_version

Sql> select * from Product_component_version;

PRODUCT                                                 VERSION             STATUS           
--------------------------------------------------------------------------- ------------------
nlsrtl                                                  11.1.0.7.0           Production
Oracle Database 11g Enterprise Edition                  11.1.0.7.0           64bit Production
pl/sql                                                  11.1.0.7.0           Production
TNS for Linux:                                          11.1.0.7.0           Production

Sql>

Method Three: Dbms_output.put_line (dbms_db_version.version)

Sql> SET serveroutput on
sql> EXEC dbms_output.put_line (dbms_db_version.version);
One

Pl/sql procedure successfully completed.

Sql>

Oracle Database History

Since version 5, Oracle ' s RDBMS release numbering has used following codes:oracle Oracle v5 V6 Oracle8 database:8.0.3–8.0.6 oracle8i Database release 1:8.1.5.0–8.1.5.1 oracle8i database release 2:8.1.6.0–8.1.6.3 Or acle8i Database Release 3:8.1.7.0–8.1.7.4 oracle9i database release 1:9.0.1.0–9.0.1.5 (Patchset as of December 2003) Ora Cle9i Database Release 2:9.2.0.1–9.2.0.8 (Patchset as of April 2007) Oracle database 10g release 1:10.1.0.2–10.1.0.5 (PA Tchset as February 2006 Oracle Database 10g release 2:10.2.0.1–10.2.0.5 (Patchset as April) Oracle database 1 1g Release 1:11.1.0.6–11.1.0.7 (Patchset as a September 2008) Oracle Database 11g release 2:11.2.0.1–11.2.0.3 (patchset As of September 2011)

The version-numbering syntax within each release follows the pattern: Major.maintenance.application-server.component-specific.platform-specific.

For example, ' 10.2.0.1 for 64-bit Solaris ' means:10th major version of Oracle, maintenance level 2, Oracle Application Se RVer (oracleas) 0, Level 1 for Solaris 64-bit.

In addition, Fenng has done a survey on the use of database version, from the figure can be seen at this stage in China, the use of 10GR2 version is still the vast majority.