Collections:
Use NULL as Conditions in Oracle
How To Use NULL as Conditions in Oracle?
✍: FYIcenter.com
If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "<>" against NULL. The sample script below shows you some good examples:
SELECT 'A' IS NULL FROM DUAL; -- Error: Boolean is not data type. -- Boolean can only be used as conditions SELECT CASE WHEN 'A' IS NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; FALSE SELECT CASE WHEN '' IS NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 0 IS NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; FALSE SELECT CASE WHEN NULL IS NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 'A' = NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; -- Do not use "=" FALSE SELECT CASE WHEN 'A' <> NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; -- Do not use "<>" FALSE SELECT CASE WHEN NULL = NULL THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; -- Do not use "=" FALSE
⇒ Concatenate Two Text Values in Oracle
⇐ What Is NULL Value in Oracle
2019-12-02, 1335👍, 0💬
Popular Posts:
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...