Oracle Apex - Metadata

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

3 - 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_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

4 - 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:

apex/metadata.txt ยท Last modified: 2015/03/11 10:28 by gerardnico