In this episode, Anton and Hayden talk about
1. How debug Level 9 can sometimes offer suggestions for writing better SQL
2. How the use of an undocumented feature called “apex_plugin_util.is_component_used” can help spare ourselves from having to rewrite SQL that the APEX team has already written.
Useful links
Please vote for Anton’s feature request to get this function documented! Access it here:
https://apex.oracle.com/ideas/FR-2240
See all APEX Instant Tips related Feature Requests
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #177: The second 5 minutes of almost every code review
For this episode, log into your APEX development workspace and follow along with this code review....
Read more
APEX Instant Tips #176: “Session State Protection” vs “Value Protected”
2 settings, Session State Protection and Value Protected, and 3 places they can apply. Anton and...
Read more
APEX Instant Tips #175: Why is my APEX item null? What is item “Storage”?
Be aware of the order of operations in APEX. Keep this in mind: Processes happen before...
Read more
APEX Instant Tips #174: Dynamic Actions and Order of Execution
Dynamic actions have brought client-side JavaScript to everyone, but it is still important to understand a...
Read more
APEX Instant Tips #173: Naming User Preferences
Anton teams up with very special guest Hayden Hudson to add a follow up on epsisode...
Read more
APEX Instant Tips #172: Region Template Best Practices
Standard? Blank with Attributes? Blank with Attributes (No Grid)? When should I use each of these...
Read more
APEX Instant Tips #171: APEX v24.2 Opening Modal Dialog Pages
When upgrading to APEX v24.2 be sure to fix custom javascript that opens modal dialog pages...our...
Read more