Find an APEX Component ID in all Oracle APEX Dictionary Views
OK Pretty niche, but if you ever want to find which columns in which views an APEX Component ID resides in, here’s a brute force approach for you:
DECLARE
l_id NUMBER := 7128208610686091; -- Change to your component ID
l_sql VARCHAR2(4000);
...
mattmulvaney.hashnode.dev1 min read
Zoran Tica
♠ Oracle ACE Pro | Database & APEX Specialist | OCP Certified | Blogger & Conference Speaker | IT Enthusiast
Hi Mat! Great snippet and thank You for that!
Just to mention - some dictionary views are not listed in APEX_DICTIONARY view, for example APEX_APPL_EXPORT_COMPS. Don't ask why... that's the question for APEX DEV team.