The goal I’m trying to achieve is to hide a column if all its values result in null or null.
<code> CREATE TABLE m_value_tbl (net_value, net_con,total_net) AS
SELECT cast(NULL as number), cast(0 as number), cast(NULL as number) FROM DUAL
UNION ALL
SELECT cast(NULL as number), cast(2 as number), cast(NULL as number) FROM DUAL ;
</code>
<code> CREATE TABLE m_value_tbl (net_value, net_con,total_net) AS
SELECT cast(NULL as number), cast(0 as number), cast(NULL as number) FROM DUAL
UNION ALL
SELECT cast(NULL as number), cast(2 as number), cast(NULL as number) FROM DUAL ;
</code>
CREATE TABLE m_value_tbl (net_value, net_con,total_net) AS
SELECT cast(NULL as number), cast(0 as number), cast(NULL as number) FROM DUAL
UNION ALL
SELECT cast(NULL as number), cast(2 as number), cast(NULL as number) FROM DUAL ;
The expected result is;
<code> net_value net_con total_net
null 2 null
</code>
<code> net_value net_con total_net
null 2 null
</code>
net_value net_con total_net
null 2 null
What I tried is the following
<code> SELECT
net_value
,net_con
,TOTAL_NET
from m_value_tbl
where
(net_value IS NOT NULL
OR net_con IS NOT NULL
OR total_net IS NOT NULL)
</code>
<code> SELECT
net_value
,net_con
,TOTAL_NET
from m_value_tbl
where
(net_value IS NOT NULL
OR net_con IS NOT NULL
OR total_net IS NOT NULL)
</code>
SELECT
net_value
,net_con
,TOTAL_NET
from m_value_tbl
where
(net_value IS NOT NULL
OR net_con IS NOT NULL
OR total_net IS NOT NULL)