APEX App Builder

APEX Workspaces

@/u01/dba/apx/apexwspace.sql

set linesize 200

set pagesize 40

column workspace_id format 999999999999999999

column workspace format a30


SELECT workspace_id, workspace

FROM apex_workspaces

WHERE workspace != 'INTERNAL'

ORDER BY workspace_id;

APEX Applications

@/u01/dba/apx/apexapps.sql

set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15


SELECT application_id, workspace, application_name, owner, version

FROM apex_applications

WHERE workspace != 'INTERNAL'

AND availability_status !='Unavailable'

ORDER BY application_id;

To identify all APEX Applications on Source database (including Unavailable apps)

@/u01/dba/apx/apexallapps.sql

set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15

column availability_status format a30

column workspace format a30


SELECT application_id, workspace, application_name, owner, version, availability_status

FROM apex_applications

WHERE workspace != 'INTERNAL'

ORDER BY application_id;