SQL查询值为null

在执行sql语句时，查询值为null使用is而不是=。

**SQL> select ename,job,sal from emp where comm is null;
ENAME      JOB              SAL
---------- --------- ----------
SMITH      CLERK            800
JONES      MANAGER         2975
BLAKE      MANAGER         2850
CLARK      MANAGER         2450
SCOTT      ANALYST         3000
KING       PRESIDENT       5000
ADAMS      CLERK           1100
JAMES      CLERK            950
FORD       ANALYST         3000
MILLER     CLERK           1300
10 rows selected.

SQL> select ename,job,sal from emp where comm = null;

no rows selected