We typically use Static List of Values (LOVs) as, well, standard APEX LOVs. They can also be used in custom components such as plug-ins, PL/SQL regions, and more–with many advantages. Static LOVs make data deployment easy, provide multi-lingual capabilities, and allow for build options, authorization schemes, and row-level conditions. With all these features, why would you bother with your own reference code table?
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #123: Often overlooked – APEX Access Control Lists
Another feature we often overlook: APEX Access Control Lists (ACLs)...or, the difference between Authorizations and Roles
Read more
APEX Instant Tips #122: Static LOVs for Benefits Beyond Standard APEX Components
APEX LOVs can be used in custom components such as plug-ins, PL/SQL regions, and more. Anton...
Read more
APEX Instant Tips #121: APEX Utilities Everywhere
In this episode, Anton and Michelle discuss the complexities of finding the utility in APEX that...
Read more
APEX Instant Tips #120: Another reason to use Template Components
What can you do with Template Components in 5 minutes? Anton and Hayden build one to...
Read more
APEX Instant Tips #119: APEX Debug Trivia
What happens with APEX Debug? What ends up in the log? Find the answers to...
Read more
APEX Instant Tips #118: Fidgeting with APEX Interactive Report Widget
Anton and Hayden show you how to improve your UX options in Interactive Reports using APEX...
Read more
APEX Instant Tips #117: Global Meta Search
Leveraging APEX Metadata within new the new APEX 22.2 feature called Search Configurations. Useful links included.
Read more
APEX Instant Tips #116: Breadcrumb Redux: The Super Breadcrumb region plug-in
Following up on episode 114, Hayden introduces Anton's new Super Breadcrum region plugin, which includes a...
Read more