Oracle SQL & PL/SQL

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; HOME