Collections:
What Is NULL Value in Oracle
What Is NULL Value in Oracle?
✍: FYIcenter.com
NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most operations has special rules when NULL is involved. The tutorial exercise below shows you some examples:
SET NULL 'NULL'; -- Make sure NULL is displayed SELECT NULL FROM DUAL; N - N U L L SELECT NULL + NULL FROM DUAL; NULL+NULL ---------- NULL SELECT NULL + 7 FROM DUAL; NULL+7 ---------- NULL SELECT NULL * 7 FROM DUAL; NULL*7 ---------- NULL SELECT NULL || 'A' FROM DUAL; N - A SELECT NULL + SYSDATE FROM DUAL; NULL+SYSD --------- NULL
2019-12-02, 881👍, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...