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 ...

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.