NULLIF
NULLIF
The NULLIF function compares two arguments expr1 and expr2. If expr1 and expr2 are equal, it returns NULL; else, it returns expr1. Unlike the other null handling function, first argument can't be NULL.Syntax
NULLIF (expr1, expr2)The below query returns NULL since both the input values, 12 are equal.
SELECT NULLIF (12, 12)
FROM DUAL;
Similarly, below query return 'SUN' since both the strings are not equal.
SELECT NULLIF ('SUN', 'MOON')
FROM DUAL;
Login in to like
Login in to comment