Query:
select empno,ename,sal,
case when sal < 1000 then 'color:red;font-weight:bold;'
when sal between 1000 and 2000 then 'color:purple;font-weight:bold;'
when sal > 2000 then 'color:green;font-weight:bold;'
end sal_stytle
from emp
更多颜色可以使用:
http://www.w3schools.com/html/html_colornames.asp
Report Attributes > Column Attributes for “SAL” > Column Formatting > HTML Expression
<span style="#sal_stytle#">#SAL#</span>
参考:
【1】http://tylermuth.wordpress.com/2007/12/01/conditional-column-formatting-in-apex/
【2】http://www.w3schools.com/html/html_colornames.asp
【3】http://apex.oracle.com/pls/apex/f?p=50942:82:0:::::
【4】http://apex.oracle.com/pls/otn/f?p=11933:7:1324712622148901::NO:::