Oracle APEX - Using LOVs in Queries and PL/SQL

I was struggling to find out how I could create SQL Queries in APEX so that I could translate from values that are in LOVs.

Then I crossed paths with the function APEX_ITEM.TEXT_FROM_LOV which does exactly what I was looking for.

So this is my tip: if you want to translate a value from the database into a value that is in a LOV, use this really nice function!

Comments

Post a Comment

Popular posts from this blog

What everybody should know about Oracle APEX

This is a really nice feature of every Oracle Database and you can get it by: Requesting an account in apex.oracle.com Creating an account in Oracle Cloud and provisioning an always free Autonomous Transaction Processing (ATP) Download and install the Oracle XE With APEX you can create really cool applications in minutes, based on your dataset (oracle database tables) or REST APIs. Take a change!
Read more