APEX Instant Tips #54: Write SQL like APEX

10Dec

APEX Instant Tips #54: Write SQL like APEX

By: Marc Ruel On: December 10, 2021 In: APEX Developer Solutions, Instant Tips Comments: 0

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

https://insum.talan.com/resources/apextips/

Insum's APEX Instant Tips: Every Friday at 12:05pm EST

Join Anton and Hayden every Friday at 12:05pm EST live on our Facebook and YouTube channels, as they present a new APEX tip every week.

APEX Instant Tips #54: Write SQL like APEX