Select current APEX version and user schema

-- Select current APEX user over all_users/dba_usersselect 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_200200

-- 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 20.2.0.00.20

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

-- VERSION_NO API_COMPATIBILITY PATCH_APPLIED
----------------------------------------------------
-- 20.2.0.00.20 2020.10.01 APPLIED