Code Copy n Paste

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!

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!