Oracle Tip: Understand how ... On the surface, it may appear that the SQL clauses IN and EXISTS are interchangeable. ... NULL. For example: select ‘true’ from dual where 1 not in (null,2); ...