oracle常用函数积累

• 空值转换

select nvl(null,'为空') from dual;

select nvl2('12','非空','为空') from dual;