APEX-AT-WORK no image
Tags:

Select current APEX version and user schema

Von Tobias Arnhold 11.19.2010
If you didn't know how you can easily select the current APEX version or the current APEX database user APEX_xxxxx. You can use these selects:

-- Select current APEX user over all_users/dba_users
select max(u1.username) as current_apex_user
from all_users u1
where u1.username like 'APEX%'
and REGEXP_LIKE (substr(u1.username,'6',1), '^[0-9]*$');

-- CURRENT_APEX_USER
---------------------
-- APEX_040000

-- Select current version over dba_registry
select comp_name, version from dba_registry
where comp_name = 'Oracle Application Express';

-- COMP_NAME VERSION_NO
-------------------------------------------
-- Oracle Application Express 4.0.1.00.03

-- Select current version over apex_release
select * from apex_release;

-- VERSION_NO API_COMPATIBILITY PATCH_APPLIED
----------------------------------------------------
-- 4.0.1.00.03 2010.05.13 null

Post Tags:

1 One Comment " Select current APEX version and user schema "

Alvaro Uribe 12 July, 2017 18:10

I think substr(u1.username,'6') should be used instead, as it is right now, the code inly validates 1 character '0'