Oracle / PeopleTools / SQL
Comparing NULLs in Oracle SQL
Nulls are special in Oracle SQL – we can’t directly compare them since they won’t equal anything including themselves.
Use Oracles NVL() function to compare fields that may contain Null values
