Wednesday, February 13, 2019

Condition wise column data color

1. create clasic report

select ename,sal,deptno
    case when sal<2000 then 'red'
         when sal between 2001 and 5000 then 'purple'
         when sal >5000 then 'green'
         end COLOR_CTL
from scott.emp;

--
2. sal column -->Apperance --> sal -->column formating a paste
<span style="clor:#COLOR_CTL#";font-weight:bold;">#sal#</span>

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/