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!

How to order the select list in chronological order

Christian Pitet 23 days ago

Hi,

Under Oracle APEX 24.2.7, I have an select list type item on p.31 of application 102. I didsplays the years randomly but not in chronological order. This is the select :

select distinct to_char(trunc(date_, 'year'), 'yyyy') d, to_char(trunc(date_, 'year'), 'yyyy') r
 from EL_ENREGISTREMENT_COMPTABLE

This is the result :

How to order the list chronologically ?

Best regards.

This post has been answered by Steve Muench-Oracle on Aug 29 2025

Jump to Answer

Added 3 days ago

2 comments

105 views