oracle nvl和nvl2的区别

1.nvl(value1,value2)：value1为null时，返回value2;否则返回value1
select nvl(1,2) nvl from dual;

select nvl(null,2) nvl from dual;

2.nv2(value1,value2,value3)：value1不为null时，返回value2;否则返回value3

select nvl2(1,2,3) nvl2 from dual;

select nvl2(null,2,3) nvl2 from dual;


附加：
nullif(value1,value2)：不相等返回value1,否则返回null

select nullif(1,2) from dual;

select nullif(2,2) from dual;