i have this statement: select quick_info from candidatetb where sid = :P200_SID and candidatelevel = '0' and rownum <= 1

quick info is a clob table with text, so the question is, is there a solution with a case or other statement to find text inside the select like "N/A" and make them in a color "red" in the result? the result is visible in a page item in oracle apex. So to make it clear, the complete result is displayed in the item and the N/A is in color red.

thanks for your help :-)

i have this statement: select quick_info from candidatetb where sid = :P200_SID and candidatelevel = '0' and rownum <= 1

quick info is a clob table with text, so the question is, is there a solution with a case or other statement to find text inside the select like "N/A" and make them in a color "red" in the result? the result is visible in a page item in oracle apex. So to make it clear, the complete result is displayed in the item and the N/A is in color red.

thanks for your help :-)

• plsql
• oracle-apex

1 Answer 1

Just do a replace when you're initializing the page item. Make sure to set the page item as format:HTML

select REPLACE(CLOB_DATA,'N/A','<span style="color:red;">N/A</span>') as clob_data
  from YOUR_TABLE fetch first 1 rows only