Shame on me....it should read:
> If there is a NULLABLE column named 'c1' and....
>
>
> ----------
> Von: ramakrishna.gv_at_db.com[SMTP:ramakrishna.gv_at_db.com]
> Gesendet: Dienstag, 9. Januar 2001 07:10
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: Go NULL values into an index?
>
> Hi Jeffery
> u meant to say that there is some way to put null values in not null
> column.
> Would u tell me how to do that.
>
> Thanks & Regards
> ----------------------------
> Ram
> Tel:4236953
>
>
> ---------------------------------------- Message History
> ----------------------------------------
>
>
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: ORACLE-L_at_fatcity.com
> cc:
>
>
>
> AHA! It's a trick question...you shouldn't be able to put null values in
> a
> not null field--not to say that it can't be done, but that is beyond the
> scope of this question. :) Just so we get this right, it is supposed to
> be
> a nullable column, right?
>
> Jeffery Stevenson
> Chief Databeast Tamer, late at night with a tummy full of Coronas!
> Medical Present Value, Inc.
> Austin, TX
>
> -----Original Message-----
> [mailto:Andreas.Haunschmidt_at_voest.co.at]
> Sent: Monday, January 08, 2001 9:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Board Members!
> Maybe a often posed question,
> but I dare to ask you directly:
>
> If there is a not null column named 'c1' and
> this column is part of an index
> - eg.: create (unique) index idx1 on t1(c1,c2...) -
> will the null values "go" into the index, so that a
> select * from t1 where c1 is null;
> or any other select statement
> can make use of the index ?
> Thanks in advance!
>
> Andreas
> Andreas
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Haunschmidt Andreas VASL/FAS
> INET: Andreas.Haunschmidt_at_voest.co.at
>
> 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: Jeffery Stevenson
> INET: jeff_at_mpv.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:
> INET: ramakrishna.gv_at_db.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 Jan 09 2001 - 06:51:32 CST
