Connected to an Oracle server by SQL Developer or another database management tool, do you need to know the exact version of the DBMS? This simple command returns a clear result for all versions of Oracle Database, the database server to consult. This request is identical, whether the Oracle server is installed on a Windows or Linux / UNIX OS.
Code:
1 2 3 | select * from v$version ; |
Result on Oracle 19c:
1 2 3 | Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
Result on Oracle 12c R2:
1 2 3 4 5 6 7 | Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production PL/SQL Release 12.2.0.1.0 - Production "CORE 12.2.0.1.0 Production" TNS for 64-bit Windows: Version 12.2.0.1.0 - Production NLSRTL Version 12.2.0.1.0 - Production |
Result on Oracle 12c R1:
1 2 3 4 5 6 7 | Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production PL/SQL Release 12.1.0.2.0 - Production "CORE 12.1.0.2.0 Production" TNS for 64-bit Windows: Version 12.1.0.2.0 - Production NLSRTL Version 12.1.0.2.0 - Production |
Result on Oracle 11g R2:
1 2 3 4 5 6 7 | Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production |
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 gone from version 12c to 18c to name its new versions according to the year of release. Note that Oracle Database 12c was released in July 2013 and 12.2 (12c R2) in September 2016.
