Message-Id: <10645.118860@fatcity.com> From: "Weerd Kirsten, E.C. de" Date: Tue, 10 Oct 2000 14:07:27 +0100 Subject: RE: NULL value NULL values are sometimes stored. Could well be in bit map indexes ... But they are definately not stored in simpe unique indexes ... > -----Original Message----- > From: Joseph S. Testa [SMTP:teci@oracle-dba.com] > Sent: Tuesday, October 10, 2000 1:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: NULL value > > i thought null values WERE stored in bit map indexes. > > although it is early. i could have dreamed it. > > joe > > > "Weerd Kirsten, E.C. de" wrote: > > > Hey, I just learned this yesterday :-) > > > > Null-values are neverd stored in indexes, and will not trigger a > constraint > > like UNIQUE ... > > So, I suppose NULL is not a value, so what is it. It's like asking : > what is > > nothing ... :-) > > > > > -----Original Message----- > > > From: awaisb@paktel.com [SMTP:awaisb@paktel.com] > > > Sent: Tuesday, October 10, 2000 12:26 PM > > > 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. > > > Q:- I have a table 'A' have one field 'X' with unique constraint, so a > > > unique index will be created for it. I inserted null into this field > two > > > times (or more then it). > > > > > > 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@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@fatcity.com (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Weerd Kirsten, E.C. de > > INET: Kirsten.deWeerd@Oranjewoud.nl > > > > 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@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: teci@oracle-dba.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@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may