Advanced Search

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