About

Report Columns

Articles Related

Metadata

In the below example, the metadata query goes against the original tables.

SELECT   pageCol.*
  FROM WWV_FLOW_WORKSHEET_COLUMNS pageCol
  , 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