Check the version of an Oracle server

Connected to an Oracle server by SQL Developer or another database management tool, you need to know the exact version of the SGBD ? This simple command returns a clear result for all Oracle Database versions the database server to be consulted. This request is identical, whether the Oracle server is installed on a OS Windows or Linux / UNIX .

The order

  select * from v$version ; 

Result on Oracle 19c :

 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0.0.0 - Production

version oracle 19c 19 database

Result on Oracle 12c R2 :

 Oracle Database 12c Enterprise Edition Release 12.2.0.0.1.0 - 64bit Production PL/SQL  Release 12.2.0.0.1.0 - Production " ProductionCORE  12.2.0.0.1.0 Production"  TNS  for 64-bit Windows: Version 12.2.0.0.1.0 - Production  NLSRTL  Version 12.2.0.0.1.0 - Production

version Oracle 12c r2 12.2

Result on Oracle 12c R1 :

 Oracle Database 12c Enterprise Edition Release 12.1.0.0.2.0 - 64bit Production PL/SQL  Release 12.1.1.0.2.0 - Production " Release 12.1.0.2.0CORE  12.1.1.0.2.2.0 Production"  TNS  for 64-bit Windows: Version 12.1.1.0.2.0 - Production  NLSRTL  Version 12.1.1.0.2.0 - Production

version Oracle 12c r1 12.1

Result on Oracle 11g R2 :

 Oracle Database 11g Enterprise Edition Release 11.2.0.0.1.0 - 64bit Production PL/SQL  Release 11.2.0.0.1.0 - Production " ProductionCORE  11.2.0.0.1.0 Production"  TNS  for 64-bit Windows: Version 11.2.0.0.1.0 - Production  NLSRTL  Version 11.2.0.0.1.0 - Production

version Oracle 11g R2 11.2

For information, and if there is indeed an Oracle 18c version released in 2018, there has never been an Oracle 13, 14, 15, 16 or 17. The American publisher has moved from version 12c to 18c to name its new versions according to the year of release. Namely that Oracle Database 12c was released in July 2013 and 12.2 (12c R2) in September 2016.