Oracle Apex - Report Columns (RPT COLS)

About

Report Columns

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:


Powered by ComboStrap