We can note that the three latest versions were all released in the third quarter of the year, so the initial version for all of them is YY.3.0.īesides the numbering, Oracle uses some letters as a commercial “punch” to identify a version with specific features. (Lets hope they change this convention before the year 2118) Oracle Version Examples Version You can check the Database Upgrade Guide to learn more about them. The second number represents the quarterly update, and the third represents the quarterly revision. The first number or version is the year in which the product is released. Since 2018, Oracle changed the numbering convention. The third and fourth numbers represented patch-sets, which were essentially bug fixes. The second referenced the release, a release was created when new features were included but without a major rewriting of the software. The first representing the major-version, which incremented on substantial changes. Oracle Database products until 2018 were identified with a sequence of 4 numbers. In order to be able to identify with precision each product, Oracle uses a numbering convention that allows to identify them. Like most software products, Oracle Database is constantly evolving, adding new features and fixing issues. Each database version is available in several edition, like Express, or Standard. In Oracle-land a version is a release of the database (eg 11.2). Finding the Oracle version in log files.Finding the Oracle version at connection time.Finding the Oracle version while connected to Oracle.

Toad version for oracle 19c