Application Express Helpful Queries

Find Apex Installations

SELECT * FROM ALL_USERS WHERE USERNAME LIKE 'APEX%';

Find Apex Workspaces

SELET WORKSPACE FROM APEX_nnnnnn.APEX_WORKSPACES;

Find Apex Users

SELECT USER_NAME FROM APEX_nnnnnn.WWV_FLOW_FND_USER;