NULL in Oracle NULL = NULL ? SELECT CASE WHEN NULL = NULL THEN 'NULL Equals to NULL' ELSE 'NULL is NOT Equals to NULL' END NULL_ FROM DUAL; NULL_ NULL is NOT Equals to NULL COUNT with NULLs WITH tab AS (SELECT 10 a FROM DUAL UNION ALL SELECT NULL a FROM DUAL UNION ALL SELECT 2 a FROM DUAL) …