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 #168: Two approaches to applying CSS to APEX components
A couple of ways to approach changing the look and feel of your application. We'll also...
Read more
APEX Instant Tips #167: APEX sessions, APEX engine requests – Behind the scenes
Anton and Marwa discuss the underpinnings of the APEX engine, including ORDS, and demonstrate using trace...
Read more
APEX Instant Tips #166: Using the browser network inspector for APEX environment insights
Have you ever seen this error when you click save? "Error: SyntaxError: Unexpected token DOCTYPE... is not...
Read more
APEX Instant Tips #165: You Must Markdown This Tip
How to make your optional label templates start in column 1 and how to publish your...
Read more
APEX Instant Tips #164: Three Tips, Workarounds, Hacks…you be the judge.
Tips on how to resize regions, show warnings on dynamic actions, and keep your region "page...
Read more
APEX Instant Tips #163: APEX_DEBUG tips and quirks
This week, Anton and Marwa cover APEX_DEBUG.ENTER, .INFO, .MESSAGE, .WARN, .ERROR and more...Happy New Year!
Read more
APEX Instant Tips #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read more
APEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read more
