-- if 1rst arg = 2nd arg then returns null

SELECT nullif(10, 10) FROM DUAL; -- returns null as 10 = 10

-- example: divides by 1 if value is null

SELECT 100 / nvl(nullif(0 /* value to test */, 0) ,1) FROM DUAL;