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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...