Hayden Hudson returns as Anton’s special guest for a tip involving APEX’s metadata-driven architecture. They dig into the Metadata of APEX and the Database itself thanks to an augmented version of the APEX standards tracking application and the database feature PLSCOPE.
Useful links:
Hayden’s public standards project. Collaborators are welcome.
https://github.com/hhudson/code_standard_tracking
To explore PLSCOPE as a primer
https://livesql.oracle.com/
PLSCOPE Direct link
https://livesql.oracle.com/apex/f?p=590:49:::NO:RP,49:P49_SEARCH:plscope
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX 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 moreAPEX Instant Tips #150: Rarely Used Region Types (RURTs)
Different Region Types, including the Toggle Column Report Region, Avatar Region, Reflow Region, and Smart Filters.
Read moreAPEX Instant Tips #149: APEX Dev Team Magic: APEX Item Plug-in
Anton and Marwa show you a magical query. No matter what type of LOV definition you...
Read moreAPEX Instant Tips #148: Protect Ajax Callback processes from hacking
Last week, we made it easy to use Ajax Callback processes. This week, we show how...
Read moreAPEX Instant Tips #147: Why are Ajax Callback processes so hard to use?
Ajax callbacks are hard to use: Learn the javascript and be careful about syntax. Marwa and...
Read moreAPEX #146: APEX Instant Tips #146: Extending Faceted Search
Hosts Anton and Marwa talk about how to make a page item look and behave like...
Read moreAPEX Instant Tips #145: How to know if the data in your Interactive Grid row changed
:APEX$ROW_STATUS is a pseudo column that can be used in PL/SQL, just like any other interactive...
Read more