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