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
