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, 1963🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...