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 #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read moreAPEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read moreAPEX 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 moreAPEX 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 moreAPEX Instant Tips #154: How to Recenter a Map Region
What is this episode about? Hint: Initial position in zoom, isn’t enough…
Read moreAPEX Instant Tips #153: Everything you always wanted to know about combobox but never thought to ask
With Combo boxes, you must manage your business rules and watch for multi-user concurrency issues. Anton...
Read moreAPEX Instant Tips #152: APEX.debug
In this episode, Anton and Marwa compare Console.log, APEX_debug.log, APEX_debug.message, and APEX.debug.setlevel.
Read moreAPEX Instant Tips #151: Updates to tips 148, 146 & 53
A review and update of 3 previous instant tips: Checksum, Faceted Search, and Multilingual Apps from...
Read more