Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: NULL value
It's stored in the column because NULL != NULL. The only operators that
can be applied to the NULL value are IS and IS NOT. Nothing else.
-----Original Message-----
From: awaisb_at_paktel.com [mailto:awaisb_at_paktel.com]
Sent: Tuesday, October 10, 2000 7:26 AM
To: Multiple recipients of list ORACLE-L
Subject: NULL value
Hi,
I have a logical question, any one who can make it clear.
create table a (x number(2) unique); insert into a values (null); 1 row created. insert into a values (null); 1 row created.
If null is a value, Why these null stored into table which have unique
constraint?
If null is not a VALUE then what it is?
Is there some special character for NULL?
If null is not a value why we have operators for null?
Regards
Muhammad Awais
System Developer
Paktel Ltd. Pakistan
Mob. 0303 7757077
(92-51) 111-222-111-282
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: awaisb_at_paktel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Oct 10 2000 - 09:38:19 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).