Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: NULL value

RE: NULL value

From: Weerd Kirsten, E.C. de <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Tue, 10 Oct 2000 14:07:27 +0100
Message-Id: <10645.118860@fatcity.com>


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_at_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_at_paktel.com [SMTP:awaisb_at_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_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-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_at_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_at_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_at_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_at_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
Received on Tue Oct 10 2000 - 08:07:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US