Table of Contents

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:

View List

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