Oracle SQL - What Is NULL
Interview Question Database For Software Developers
|
|
| What Is NULL | | What Is NULL? - Oracle DBA FAQ - Understanding SQL Basics | | By: 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
opertations 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
| | ID: 820 | Rank: 1079 | Votes: 0 | Views: 33 | Submitted: 20070423 |
1079
:-) | | What Is NULL | | What Is NULL? - Oracle DBA FAQ - Understanding SQL Basics... | | Submitted: 20070423 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view