This content has been marked as final. Show 7 replies
Coalesce can take multiple arguments. NVL only two arguments
I think you missed my point .
What I wanted to explain
Both COALESCE and NVL need the all parameter are of same type.
Other wise will give Errors ( error type might be different )
And NVL is more flexible than COALESCE as it will try to auto convert the datatype , whiel Coalesce doesn't do that .
By stating that, I was agreeing with Michaels . :)