what is the difference between COALESCE() and NVL()?

Asked Mar 28 '17 at 09:31

Active Mar 28 '17 at 09:31

Viewed 388 times

With my practice both function's are giving same output with same functionality..!

select COALESCE(null,1) from dual; output: 1

select NVL(null,1) from dual; output: 1

asked Mar 28 '17 at 09:31

srikanth

2

possible dplicate of http://stackoverflow.com/questions/950084/oracle-differences-between-nvl-and-coalesce – beejm Mar 28 '17 at 09:33
COALESCE is ANSI SQL standard, NVL is not. – jarlh Mar 28 '17 at 10:29

0 Answers0