在执行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