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
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.
ReplyDeleteAnother good way to determine this (and DBAs would love this) is via the query:
ReplyDeleteselect version from sys.dba_registry where comp_id = 'APEX';
Joel