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
⇒ Use NULL as Conditions in Oracle
⇐ Convert Character Strings to Times in Oracle
2019-12-02, 4036🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a m...
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string usi...