Oracle Apex - Metadata

Card Puncher Data Processing

Oracle Apex - Metadata

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

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:

Oracle Apex Report Columns Metadata




Discover More
Oracle Apex Express Listener
Oracle Apex - Installation version 4 with Oracle Application Express Listener

Installation steps of Apex 4.0 with Oracle Application Express Listener as HTTP Listener. Oracle Application Express Listener is a Java-based Web server. It features file system caching, support for FOP...
Card Puncher Data Processing
Oracle Apex - Debug (Messages)

The debug facility displays application processing details through messages that can be: enabled (to a certain information ) disabled added removed See constant...
Card Puncher Data Processing
Oracle Apex - (Sql) Report (RPT)

A report can shown data as: mutable columns: When running a master detail form, data is rendered as a report. A tabular form is rendered as a report havingupdatable columns shown using various form...
Card Puncher Data Processing
Oracle Apex - Application (flows)

An application is an HTML interface that exists on top of database objects such as tables or procedures In the URL, the application number is the first number in the parameter sequence, followed...
Oracle Apex Authorization Application
Oracle Apex - Authorization

While conditions control the rendering and processing of specific controls or components on a page, authorization schemes control user access. Authorization schemes use the identities established by...
Card Puncher Data Processing
Oracle Apex - List

A list is shared collection of links. Lists is a navigation component. list of value (LOV) You add a list to a page by creating a list region. Deleting a list will cause referencing regions to be...
Card Puncher Data Processing
Oracle Apex - Plugin

Plug-Ins can create the following custom components: item types, region types, processes and Dynamic Actions. API The APEX_PLUGIN...
Oracle Apex Report Columns Metadata
Oracle Apex - Report Columns (RPT COLS)

Report Columns In the below example, the metadata query goes against the original tables. where: page_id is the page id and flow_id is the application id



Share this page:
Follow us:
Task Runner