oracle 关于null和除法的一些现象

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