APEX

Hi,

I do have Select list page item. P1_COLOR_LIST

I want to display the select list values with colors.

For this i have written below code.

P1_COLOR_LIST

List of values as Sql query.

SELECT D ,

R

FROM(SELECT

CASE WHEN deptno = 10 THEN

'<span style ="background-color:green;">'||ename||'</span>'

WHEN deptno = 20 THEN

'<span style = "background-color:red;" >'||ename||'</span>'

WHEN deptno = 30 THEN

'<span style = "background-color:yellow;" >'||ename||'</span>'

WHEN deptno = 40 THEN

'<span style = "background-color:blue;" >'||ename||'</span>'

END AS D,

empno AS R

FROM emp)

and resultant select list values as below.

But i want display the list of values with their background color.

Same query is working for the reports

Please suggest.

Thanks in advance.

Thanks,

Hanu