IS NULL Operator

• This operator tests for NULL values.
• It is the only operator that can be used to test for NULL’s.
• The negation is IS NOT NULL.

      Examples :-

       Select ename, deptno, comm from emp where comm IS NULL;

       Select ename, deptno, comm from emp where comm IS NOT NULL;

       Select ename, deptno, job, mgr from emp where mgr IS NULL;

       Select ename, deptno, job, mgr from emp where mgr IS NOT NULL;