Skip to content
Advertisement

Oracle APEX changing the colour of display only item with PL/SQL query

I have a display only item in a static content which looks like this:

enter image description here

I want to change the whole background colour of the button/item instead of the text’s colour.

My PL/SQL code looks like this for example for the first item:

SELECT case ACTUAL_SITUATION when 'Y' then '<span style="color:green">Yes</span>'
                          when 'N' then '<span style="color:red">No</span>' end as "ACTUAL_SITUATION "
FROM tableName

Is it possible to change it with PL/SQL? All I could do is change the span background colour and that was just a highlight on the text.

Advertisement

Answer

Assuming you have a “Display Only” field, set the “Source” to be a “SQL Query(return single value)” and be sure to set under “Security”, “Escape special characters” to “No” to allow the HTML to flow through. Note that you want to use background-color not color in your style to set the background.

I tested it and it works.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement