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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...