Oracle NULLIF() Function

Oracle NULLIF() Function:

The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments will null then function return an error.

  • Syntax of the NULLIF() function:
NULLIF(elm1, elm2)

Example 1:

SELECT
NULLIF ('VIKAS', 'PANDEY') COL
FROM DUAL

Example 2:

SELECT
NULLIF ('VIKAS', 'VIKAS') COL
FROM DUAL

Example 3:

SELECT
NULLIF (null, 'VIKAS') COL
FROM DUAL

Oracle Functions

You might also like: