CODE EXAMPLE FOR SQL

oracle apex warning message

SELECT APPLICATION_ID, PAGE_ID, WARN_ON_UNSAVED_CHANGES 
FROM APEX_APPLICATION_PAGES
WHERE APPLICATION_ID = <application_id>;

SELECT APPLICATION_ID, PAGE_ID, ITEM_NAME, WARN_ON_UNSAVED_CHANGES
FROM APEX_APPLICATION_PAGE_ITEMS
WHERE ITEM_NAME = <item_name>;
-- Page Designer > Page > Warn on Unsaved Changes