Skip to Main Content

Oracle Database Free

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!

How to make LOV from ENUM?

Mike KutzMay 8 2024 — edited May 8 2024

Using the pre-installed domain sys.day_enum_d for reference, how do I turn an enum into a LOV for APEX?

I'm wanting the LOV to show distinct enum_value and results of domain_display()

This doesn't work: all lov_text values are null

select distinct e.enum_value lov_id, domain_display( e.enum_value ) lov_text
from sys.day_enum_d e

(DB 23.4 VirtualBox)

This post has been answered by Chris Saxon-Oracle on May 8 2024
Jump to Answer
Comments
Post Details
Added on May 8 2024
18 comments
524 views