Ignore nulls and concatenate
I am trying to select values from one table, and insert these values into another table.field using concatenation. This works, but it adds the null values to the string also. Is there any way to ignore null values in Oracle?
Thanks.
update table1
set field1 =
(select field1||field2||field3||field4||
field5||field6 from table2
where table1.refnum = table2.refnum);