Maybe you came in the situation when you created an APEX report and during your development you unfortunately saved it with the wrong selection.
It happened a couple of times to me...
I found a way how you can restore such a lost selection easily within a SQL statement:
Just use the Oracle flashback feature inside the APEX View "APEX_APPLICATION_PAGE_REGIONS" and restore it from your redolog files. Column REGION_SOURCE includes the original selection.
It happened a couple of times to me...
I found a way how you can restore such a lost selection easily within a SQL statement:
select PAGE_ID,
PAGE_NAME,
REGION_NAME,
TEMPLATE,
STATIC_ID,
REGION_SOURCE,
SOURCE_TYPE
from APEX_APPLICATION_PAGE_REGIONS
as of timestamp sysdate - 100 / (24 * 60)
-- Minus 100 Minutes
where APPLICATION_ID = '100'
and PAGE_ID = 100;
Just use the Oracle flashback feature inside the APEX View "APEX_APPLICATION_PAGE_REGIONS" and restore it from your redolog files. Column REGION_SOURCE includes the original selection.
