RE: NULL value

NULL values ARE stored in bitmap indexes and are not stred in B*tree indexes.

-----Original Message-----
From: Joseph S. Testa [mailto:teci_at_oracle-dba.com] Sent: Tuesday, October 10, 2000 8:45 AM
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