SQL> select 0/null from dual;
0/NULL
----------
SQL> select 0/1 from dual;
0/1
----------
0
SQL> select null/1 from dual;
NULL/1
----------
SQL> select null/null from dual;
NULL/NULL
----------
SQL> select null/0 from dual;
NULL/0
----------
SQL> select 1/0 from dual;
select 1/0 from dual
ORA-01476: 除数为 0
看来只要运算中有null结果就一定为null