About
The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition:
- from page
- to columns
Articles Related
View List
- APEX_APPLICATION_ALL_AUTH
- APEX_APPLICATION_AUTH
- APEX_APPLICATION_AUTHORIZATION
- APEX_APPLICATION_BC_ENTRIES
- APEX_APPLICATION_BREADCRUMBS
- APEX_APPLICATION_BUILD_OPTIONS
- APEX_APPLICATION_CACHING
- APEX_APPLICATION_COMPUTATIONS
- APEX_APPLICATION_GROUPS
- APEX_APPLICATION_ITEMS:
- APEX_APPLICATION_LIST_ENTRIES
- APEX_APPLICATION_LISTS
- APEX_APPLICATION_LOV_ENTRIES
- APEX_APPLICATION_LOVS
- APEX_APPLICATION_NAV_BAR
- APEX_APPLICATION_PAGE_BRANCHES
- APEX_APPLICATION_PAGE_BUTTONS
- APEX_APPLICATION_PAGE_COMP
- APEX_APPLICATION_PAGE_DA
- APEX_APPLICATION_PAGE_DA_ACTS
- APEX_APPLICATION_PAGE_DB_ITEMS
- APEX_APPLICATION_PAGE_FLASH_CH
- APEX_APPLICATION_PAGE_FLASH_S
- APEX_APPLICATION_PAGE_FLASH5
- APEX_APPLICATION_PAGE_FLASH5_S
- APEX_APPLICATION_PAGE_GROUPS
- APEX_APPLICATION_PAGE_IR
- APEX_APPLICATION_PAGE_IR_CAT
- APEX_APPLICATION_PAGE_IR_CGRPS
- APEX_APPLICATION_PAGE_IR_COL
- APEX_APPLICATION_PAGE_IR_COMP
- APEX_APPLICATION_PAGE_IR_COND
- APEX_APPLICATION_PAGE_IR_GRPBY
- APEX_APPLICATION_PAGE_IR_RPT
- APEX_APPLICATION_PAGE_IR_SUB
- APEX_APPLICATION_PAGE_ITEMS
- APEX_APPLICATION_PAGE_MAP
- APEX_APPLICATION_PAGE_PROC
- APEX_APPLICATION_PAGE_REGIONS
- APEX_APPLICATION_PAGE_RPT
- APEX_APPLICATION_PAGE_RPT_COLS
- APEX_APPLICATION_PAGES
- APEX_APPLICATION_PAGE_TREES
- APEX_APPLICATION_PAGE_VAL
- APEX_APPLICATION_PARENT_TABS
- APEX_APPLICATION_PROCESSES
- APEX_APPLICATIONS
- APEX_APPLICATION_SHORTCUTS
- APEX_APPLICATION_SUBSTITUTIONS
- APEX_APPLICATION_SUPP_OBJ_BOPT
- APEX_APPLICATION_SUPP_OBJ_CHCK
- APEX_APPLICATION_SUPP_OBJECTS
- APEX_APPLICATION_SUPP_OBJ_SCR
- APEX_APPLICATION_TABS
- APEX_APPLICATION_TEMP_BC
- APEX_APPLICATION_TEMP_BUTTON
- APEX_APPLICATION_TEMP_CALENDAR
- APEX_APPLICATION_TEMP_LABEL
- APEX_APPLICATION_TEMPLATES
- APEX_APPLICATION_TEMP_LIST
- APEX_APPLICATION_TEMP_PAGE
- APEX_APPLICATION_TEMP_POPUPLOV
- APEX_APPLICATION_TEMP_REGION
- APEX_APPLICATION_TEMP_REPORT
- APEX_APPLICATION_THEMES
- APEX_APPLICATION_TRANS_DYNAMIC
- APEX_APPLICATION_TRANSLATIONS
- APEX_APPLICATION_TRANS_MAP
- APEX_APPLICATION_TRANS_REPOS
- APEX_APPLICATION_TREES
- APEX_APPLICATION_WEB_SERVICES
- APEX_APPL_LOAD_TABLE_LOOKUPS
- APEX_APPL_LOAD_TABLE_RULES
- APEX_APPL_LOAD_TABLES
- APEX_APPL_PLUGIN_ATTRIBUTES
- APEX_APPL_PLUGIN_ATTR_VALUES
- APEX_APPL_PLUGIN_EVENTS
- APEX_APPL_PLUGIN_FILES
- APEX_APPL_PLUGINS
- APEX_COMPONENT_SIGNATURES
- APEX_DEBUG_MESSAGES
- APEX_DEVELOPER_ACTIVITY_LOG
- APEX_DEVELOPER_AUDIT_LOG
- APEX_DICTIONARY
- APEX_MIGRATION_ACC_FORMS
- APEX_MIGRATION_ACC_PROJECTS
- APEX_MIGRATION_ACC_QUERIES
- APEX_MIGRATION_ACC_RPTS
- APEX_MIGRATION_ACC_TABLES
- APEX_MIGRATION_PROJECTS
- APEX_MIGRATION_REV_FORMS
- APEX_MIGRATION_REV_QUERIES
- APEX_MIGRATION_REV_RPTS
- APEX_MIGRATION_REV_TABLES
- APEX_RELEASE
- APEX_REST_RESOURCE_HANDLERS
- APEX_REST_RESOURCE_MODULES
- APEX_REST_RESOURCE_PARAMETERS
- APEX_REST_RESOURCE_TEMPLATES
- APEX_STANDARD_CONDITIONS
- APEX_SYS_ALL_CONSTRAINTS
- APEX_SYS_ALL_DEPENDENCIES
- APEX_SYS_ALL_OBJECTS
- APEX_SYS_ALL_SYNONYMS
- APEX_TEAM_BUGS
- APEX_TEAM_FEATURES
- APEX_TEAM_FEEDBACK
- APEX_TEAM_FEEDBACK_FOLLOWUP
- APEX_TEAM_MILESTONES
- APEX_TEAM_TODOS
- APEX_THEMES
- APEX_UI_DEFAULTS_ATTR_DICT
- APEX_UI_DEFAULTS_COLUMNS
- APEX_UI_DEFAULTS_GROUPS
- APEX_UI_DEFAULTS_LOV_DATA
- APEX_UI_DEFAULTS_TABLES
- APEX_WORKSPACE_ACCESS_LOG
- APEX_WORKSPACE_ACTIVITY_LOG
- APEX_WORKSPACE_APEX_USERS
- APEX_WORKSPACE_CLICKS
- APEX_WORKSPACE_DEVELOPERS
- APEX_WORKSPACE_FILES
- APEX_WORKSPACE_GROUPS
- APEX_WORKSPACE_GROUP_USERS
- APEX_WORKSPACE_LOG_ARCHIVE
- APEX_WORKSPACE_LOG_SUMMARY
- APEX_WORKSPACE_LOG_SUMMARY_USR
- APEX_WORKSPACES
- APEX_WORKSPACE_SCHEMAS
- APEX_WORKSPACE_SESSIONS
- APEX_WORKSPACE_SQL_SCRIPTS
- APEX_WS_APPLICATIONS
- APEX_WS_APP_PAGES
- APEX_WS_DATA_GRID
- APEX_WS_DATA_GRID_COL
Example
Example that shows how to get a list of Report Columns.
In the below example, the APEX schema is APEX_040100.
SELECT pageCol.*
FROM APEX_040100.WWV_FLOW_WORKSHEET_COLUMNS pageCol
, APEX_040100.WWV_FLOW_WORKSHEETS page
WHERE page.page_id = 18 -- page id
AND page.flow_id = 2109 -- application id
and pageCol.worksheet_id = page.id
ORDER BY display_order;
where:
- page_id is the page id
- and flow_id is the application id
