Query to find APEX and APEX logger version

This document describes how to find APEX logger version.

Use below query to find APEX logger version.

select pref_value from logger_prefs where pref_name = 'LOGGER_VERSION';

APEX Version:

We can find APEX version in below 2 methods from database.

Method 1:

col version_no for a30

col API_COMPATIBILITY for a20

col PATCH_APPLIED for a20

SQL> select * from apex_release;

VERSION_NO                  API_COMPATIBILITY    PATCH_APPLIED

------------------------------ -------------------- --------------------

4.2.5.00.08                   2012.01.01

SQL> 

 

Method 2:

col COMP_ID for a20

col COMP_NAME for a40

col VERSION for a25

SQL> select COMP_ID,COMP_NAME,VERSION from dba_registry;

COMP_ID      COMP_NAME       VERSION

-------------------- ---------------------------------------- -------------------------

DV      Oracle Database Vault       12.1.0.2.0

APEX      Oracle Application Express       4.2.5.00.08

OLS      Oracle Label Security       12.1.0.2.0

SDO      Spatial       12.1.0.2.0

ORDIM      Oracle Multimedia       12.1.0.2.0

CONTEXT      Oracle Text       12.1.0.2.0

OWM      Oracle Workspace Manager       12.1.0.2.0

XDB      Oracle XML Database       12.1.0.2.0

CATALOG      Oracle Database Catalog Views       12.1.0.2.0

CATPROC      Oracle Database Packages and Types       12.1.0.2.0

JAVAVM      JServer JAVA Virtual Machine       12.1.0.2.0

COMP_ID      COMP_NAME       VERSION

-------------------- ---------------------------------------- -------------------------

XML      Oracle XDK       12.1.0.2.0

CATJAVA      Oracle Database Java Packages       12.1.0.2.0

APS      OLAP Analytic Workspace       12.1.0.2.0

XOQ      Oracle OLAP API       12.1.0.2.0

RAC      Oracle Real Application Clusters       12.1.0.2.0

Thanks for going through the post...........