Nullif

Nullif is an sql function that returns a null value if both parameters are equal in value. if not,the first value will be returned.

Eg:

SELECT NULLIF(1, 2) FROM dual;

RETURN 1.

SELECT NULLIF(1, 1) FROM dual;

RETURN NULL