Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternative to COALESCE

KVBSep 5 2012 — edited Sep 5 2012
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2012
Added on Sep 5 2012
8 comments
1,869 views