RE: Go NULL values into an index?

From: <ramakrishna.gv_at_db.com>
Date: Tue, 9 Jan 2001 11:39:23 +0530
Message-Id: <10735.126081@fatcity.com>

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 ----------------------------------------

From: jeff_at_mpv.com on 09/01/2001 05:00 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: Go NULL values into an index?

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