Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select lov display value based on lov name in the same table

Hello,
I'm using Oracle Apex last edition and I'm wondering if the following is possible!

I have an interactive grid table with two columns... The first column is showing some of LOV that is stored in Shared Documents: List of Values using this query :
select LIST_OF_VALUES_NAME from apex_application_lovs;
In the second column, I want a select list type column to list all the "display values" based on the Lov name on the other column.
Is that possible?
Thanks

Comments
Post Details
Added on Nov 9 2022
4 comments
1,151 views