NVL is not a simplified form of COALESCE
SQB last edited by
SELECT COALESCE(2,1/0) FROM DUAL;
SELECT NVL(2, 1/0) FROM DUAL;
According to Oracle documentation, both should yield the same results. However, while COALESCE evaluates all branches until it finds one that is not NULL, NVL allways evaluates both branches, resulting in an error on the second statement (division by zero).
woodle last edited by
I just wanted to reply so that this and its related thread don't go unacknowledged. Keep up the good work, I personally hate Oracle just for the empty string vs null issue, it's nice to know that there are plenty of other good reasons.