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 #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read more
APEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read more
APEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read more
APEX #159: Recipes from the IG Cookbook
Marwa and Anton show you amazing things you can do with an Interactive Grid through recipes...
Read more
APEX Instant Tips #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read more
APEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read more
APEX Instant Tips #156: Informing users about background processes
Anton and Marwa discuss Background processes: informing users of what is happening and what occurs upon...
Read more
APEX Instant Tips #155: About icons and buttons builder
We have extended the Universal Theme application to allow more customization within the icon and button...
Read more
