Alternative to COALESCE
KVBSep 5 2012 — edited Sep 5 2012Hi
I have a query like this
SELECT
A,B,C,D...
FROM
A
JOIN
B ON
A.COL1=B.COL1
LEFT OUTER JOIN
C
ON
A.COL1=B.COL1
AND COALESCE(A.COL2,0)=COALESCE(C.COL2,0).
Is there any other way of coding it rather than coalesce without using nvl?
Regards
KVB