Skip to Main Content
Forums

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!

Highlighting default values on dropdown Select Lists?

User_RXRYNJun 11 2021

Using Apex 18, when a page of select lists comes up, how may I highlight the default values for each of the select list dropdowns?
For example, if I had a simple dropdown select list of the numbers 1 through 10, where the default is 7, how can I have the value of 7 automatically highlighted?
Thanks so much for your help!

Comments

Solomon Yakobson
Answer 
WITH SAMPLE(ID,FirstName,LastName,City,State,Phone,SystemDate)
  AS (
      SELECT 1,'John','Doe','ABC','FL','5555555555',DATE '2020-12-01' FROM DUAL UNION ALL
      SELECT 1,'John','Doe','ABC','FL','8888888888',DATE '2020-12-01' FROM DUAL UNION ALL
      SELECT 2,'Jane','Smith','XYZ','CA','9999999999',DATE '2020-12-01' FROM DUAL
     )
SELECT  ID,
        FirstName,
        LastName,
        City,
        State,
        LISTAGG(Phone,',') WITHIN GROUP(ORDER BY Phone) Phone,
        SystemDate
  FROM  SAMPLE
  GROUP BY ID,
           FirstName,
           LastName,
           City,
           State,
           SystemDate
/

        ID FIRS LASTN CIT ST PHONE                 SYSTEMDAT
---------- ---- ----- --- -- --------------------- ---------
         1 John Doe   ABC FL 5555555555,8888888888 01-DEC-20
         2 Jane Smith XYZ CA 9999999999            01-DEC-20


SQL>

SY.

Marked as Answer by User_OMEF8 · Dec 5 2020
1 person found this helpful
User_OMEF8

Wow! That did the trick. Thanks so much! I did not realize it would be something as simple as that.

1 - 2

Post Details

Added on Jun 11 2021
#apex-discussions
0 comments
88 views