Return to Snippet

Revision: 71257
at January 30, 2017 06:48 by bbrumm


Initial Code
--Example 1

SELECT NULLIF(23, 23) AS NULLCHECK FROM dual;


--Example 2
SELECT NULLIF(23, 29) AS NULLCHECK FROM dual;

--Example 3
SELECT NULLIF(23.000, 23) AS NULLCHECK FROM dual;

--Example 4
SELECT NULLIF('Sunday', 'Sunday') AS NULLCHECK FROM dual;

--Example 5
SELECT NULLIF('Sunday', 'Saturday') AS NULLCHECK FROM dual;

--Example 6
SELECT NULLIF('23.7', 23.7) AS NULLCHECK FROM dual;

--Example 7
SELECT NULLIF(SYSDATE, 'Someday') AS NULLCHECK FROM dual;

--Example 8
SELECT NULLIF(NULL, 'Sunday') AS NULLCHECK FROM dual;

--Example 9
SELECT NULLIF('Sunday', NULL) AS NULLCHECK FROM dual;

Initial URL
http://www.databasestar.com/oracle-nullif/

Initial Description
A few examples of the NULLIF function.

Initial Title
Oracle NULLIF Function

Initial Tags
sql, Oracle

Initial Language
SQL