admin管理员组

文章数量:1402832

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
Share Improve this question edited Mar 21 at 13:24 Steffen asked Mar 21 at 13:20 SteffenSteffen 135 bronze badges 0
Add a comment  | 

1 Answer 1

Reset to default 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

本文标签： oracle apexplsql select how to find NA in a clob columnStack Overflow

版权声明：本文标题：oracle apex - plsql select how to find NA in a clob column - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744350606a2602026.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。