null 求和 oracle,Oracle中的null与数字相加问题

在oracle中，null与数字相加减，结果为null，

所以要用nvl()函数进行处理

declare

V_Num varchar2(20);

V_Num2 varchar2(20);

V_Num3 varchar2(20);

V_Num4 varchar(20);

begin

select nvl(null,0) + 100 into V_Num from dual;

select null - 200 into V_Num2 from dual;

select 300 + null into V_Num3 from dual;

select 400 - null into V_Num4 from dual;

dbms_output.put_line(V_Num);

dbms_output.put_line(V_Num2);

dbms_output.put_line(V_Num3);

dbms_output.put_line(V_Num4);

end;