Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have two fields called PRODUCT1 and PRODUCT2 contains blank and null values.
I have convert these values into Null Text.
I have tried
NULLASVALUE "PRODUCT1","PRODUCT2";
SET NULLVALUE = 'NULL';
But i am not able to see NULL text in the above fields.
Please help me on this.
Thanks in advance.
Load
DATE,
PRODUCT1,
PRODUCT2;
Sql select
p.date,
COALESCE(p.product1,'NULL') AS p.product1
COALESCE(p.product2,'NULL') AS p.product2
from product p where to_Char(p.date,'DD/MM/YYYY') in $(WHEREPART);