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 #128: Explore the Depths of Deep Linking
Yes, you can have session state protection enabled and send deep links via email. Anton and...
Read more
APEX Instant Tips #127: VSCode Snippets
VSCode is an editor of choice, but if you have PL/SQL code that you edit in...
Read more
APEX Instant Tips #126: Making Markdown Work the Way We Want It To
In this episode, Anton and Hayden explain how to get markdown links to open in a...
Read more
APEX Instant Tips #125: A Solution for a Data Packager Issue – Special Guest Jayson Hanes
Anton and Hayden share their solution for an APEX Data Packager bug with special guest APEX...
Read more
APEX Instant Tips #123: Often overlooked – APEX Access Control Lists
Another feature we often overlook: APEX Access Control Lists (ACLs)...or, the difference between Authorizations and Roles
Read more
APEX Instant Tips #122: Static LOVs for Benefits Beyond Standard APEX Components
APEX LOVs can be used in custom components such as plug-ins, PL/SQL regions, and more. Anton...
Read more
APEX Instant Tips #121: APEX Utilities Everywhere
In this episode, Anton and Michelle discuss the complexities of finding the utility in APEX that...
Read more