Sure why not! I thought I had already answered the question before, so I searched on the OTN forum but didn’t find my posting. No problem, shouldn’t be too hard to find the solution again.
My first attempt was to use the span tag with the style attribute in the lov query, like
SELECT '<span style="background-color:red">'|| DESCRIPTION|| '</span>' AS D , OID AS R FROM REQUEST_STATUS ORDER BY OID
Nice try, but it didn’t work, because the span tag is ignored for select list elements.
My next attempt was to change the option tag which Oracle Application Express (APEX) generates. Like with the following lov query
SELECT DESCRIPTION AS D , OID||'" style="background-color:red' AS R FROM REQUEST_STATUS ORDER BY OID
Why? Because I modified the index column by adding the ” style=…, so Oracle Application Express (APEX) wasn’t able to map the database column value to the select list entry anymore. So that wasn’t really a working solution.
BTW, if you have a Firefox only environment, you can also assign images. Too bad that Internet Explorer doesn’t support it. The code for example would be:
BTW, you can also put the stuff into a CSS and assign a class to the option.
Don’t think that I really have solved that in the past, must have been something else with select lists.