Skip to Main Content

Apex version (regular expressions)

Version NoV1V2V3V4V5
24.2.32423 - -

A quick 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').

As a side note: you can get the Apex patch version (if it exists) with a query like this:

Apex version - installation file

If you download the "latest" Apex version from https://www.oracle.com/tools/downloads/apex-downloads/, you end up with a file called apex-latest.zip.
A quick way to find the version of that Apex installation file is to open the zip file and view this file in a text editor: \apex\core\scripts\set_appun.sql
It should say something like: define APPUN = 'APEX_240200'.

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 a few years ago, 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, regard 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

Last Update: 2025-03-27 oracle apex application express sql pl/sql tedstruik.nl tedstruik-oracle.nl