2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

Differences between NVL and Coalesce

What is the main difference between NVL and Coalesce.
userimage

Coalesce can take multiple arguments.

NVL only two arguments

COALESCE doesn't evaluate anything after it finds the first non-NULL argument

NVL always evaluates both arguments 

COALESCE is more modern function that is a part of ANSI-92 standard.

NVL is Oracle specific, it was introduced in 80's before there were any standards.


Answer is