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 #98: An easier way to give secure access to a REST enabled schema
Anton describes how to give access to a REST-enabled schema by simply granting the SQL developer...
Read more
APEX Instant Tips #97: What should :APP_USER contain?
For active APEX users, switching user names can be a major inconvenience. Anton recommends setting APP_User...
Read more
APEX Instant Tips #96: monitor your query with automations
In this episode, Anton and Hayden recommend trying automations when IR subscriptions don't quite meet your...
Read more
APEX Instant Tips #95: Making the most of a navigation menu
Anton and Hayden provide an efficient solution for how to replicate the redundant menu design pattern...
Read more
APEX Instant Tips #94: Creating shortcuts in APEX
Since APEX ver. 22.1 it has never been easier to create shortcuts in APEX. In this...
Read more
APEX Instant Tips #93: Using APEX App builder for design inspiration
Anton & Hayden present 5 APEX App Builder design features that can serve as inspiration for...
Read more
APEX Instant Tips #92: Using RESTful services to synch data during deployment
Struggling to deploy in APEX? REST easy, Anton and Hayden have another method to move data...
Read more
APEX Instant Tips #91: Enabling PL/SQL warnings with a logon trigger
Hayden shows Anton how to get the benefits of enabling PL/SQL warnings without a sql developer...
Read more