Friday, June 18, 2010

How to Find Current APEX Version

Last week my DBA asked me what version of APEX we were running. Instinctively I loaded up the APEX development page and looked in the bottom right hand corner:



This worked, however he needed to dynamically obtain the current version for a script that he was writing. After some digging around he sent me the following query:

SELECT *
FROM apex_release

Note: this isn't earth shattering but more for my reference

2 comments:

  1. Uncanny. I found this somewhere recently also. The site I'm at is involved in an upgrade, and we wanted to interrogate where they were at without logging into Apex.

    ReplyDelete
  2. Another good way to determine this (and DBAs would love this) is via the query:

    select version from sys.dba_registry where comp_id = 'APEX';


    Joel

    ReplyDelete