clauses IN and EXISTS are ... in an Oracle database, a NULL value means unknown, so any comparison or operation against a NULL value is also NULL, and any test that returns NULL is always ignored.

For example, Microsoft's SQL Server has an "Exists" keyword allowing you to easily check to see if a record exists; Oracle's SQL does not have this feature, but you can work around the shortcoming ...