ORACLE (is null, is not null)

null 인거

select * from emp where mgr is null;

null 아닌거
select * from emp where mgr is not null;