Search posts, tags, users, and pages
Matt Mulvaney
I do fancy stuff with Oracle APEX #orclapex
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); ...
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.
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.