Skip to Main Content

Apex version (substr/instr)

Version NoV1V2V3V4V5
20.2.0.00.202020020

Apex version (regular expressions)

Version NoV1V2V3V4V5
20.2.0.00.202020020

Apex version - Info

Two generic ways to determine the major and minor version numbers of Apex.
And since we're only dealing with integers here, no problems with NLS settings (e.g. invalid number errors when converting '4.2' on a Dutch Apex installation, which expects '4,2').

I have included both a substr/instr solution and one using regular expressions. Usually I find regular expressions rather unreadable; so while the first solution may be longer and clumsier, it is more readable (and therefore less prone to errors, I think).

Database & Apex versions

 4.2.1...4.2.44.2.54.2.6 5.0...5.0.35.0.4 5.15.1.15.1.2
                
12.2.0.1.0 NOKNOKNOKNOKNOK NOKNOKNOKOK OKOKOK
                
12.1.0.2.0 NOKNOKNOKOKOK OKOKOKOK OKOKOK
12.1.0.1.0 NOK?NOK?NOK?OKOK OKOKOKOK OKOKOK
                
11.2.0.4.0 OKOKOKOKOK OKOKOKOK OKOKOK
11.2.0.3.0 OKOKOKOKOK OKOKOKOK NOK?NOK?NOK?
11.2.0.2.0 OKOKOKOKOK OKOKOKOK NOK?NOK?NOK?
11.2.0.1.0 OKOKOKOKOK OKOKOKOK NOK?NOK?NOK?
                
11.1.0.7.0 OKOKOKOKOK OKOKOKOK NOK?NOK?NOK?
11.1.0.6.0 OKOKOKOKOK OKOKOKNOK NOKNOKNOK
                
10.2.0.5.0 OKOKOKOKOK OKOKOKNOK NOKNOKNOK
10.2.0.4.0 OKOKOKOKOK OKOKOKNOK NOKNOKNOK

Database & Apex versions - Info

While playing around with pluggable databases in 12c, I wondered what different versions of Apex could be deployed at the same time on different database versions. The idea being that having multiple versions of Apex running at the same time (and accessing the same data) would be a great help during application testing and upgrading.
Getting this info was not as simple as expected, so I thought I'd share my findings with you. So the list is "best effort" and it is not complete - I skipped Apex and database versions that are already antiques.

In the table above, "NOK?" indicates a combination of versions that might or might not be supported; the documentation is not always clear or consistent. To be safe, regards this as a "NOK".
Also note that a "NOK" doesn't mean the combination won't work; it might but it is not supported. For example, on two development servers I've had Apex 5.0.2 running on database 12.2.0.1.0 without problems.

Sources used:
https://mikedietrichde.com/2017/05/02/is-your-apex-version-certified-with-your-database-release/
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=355341795729425&id=1344948.1&_afrWindowMode=0&_adf.ctrl-state=d04kwub2_4

Code

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source