Re: Unique indexes with null columns

From: <Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com>
Date: Tue, 26 Sep 2000 14:45:04 -0400
Message-Id: <10631.117898@fatcity.com>

Yes it is.

Primary key is :
1) a unique index
2) not NULL constraints on the index fields

You have two options:

Create a primary key, identify what are the names of the NOT NULL constraints the Oracle created and drop those (have never tried it, but I think it should work)
Just create a unique index.

Val Gamerman.

To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:        (bcc: Val Gamerman/Victoria Financial)
From:     cemail_at_sprintmail.com @ NOTES NET
Date:     09/26/2000 05:20:45 PM GMT

Subject: Unique indexes with null columns

Is it possible to create a unique index on 4 columns when 2 of the columns have some nulls?

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: cemail_at_sprintmail.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). Received on Tue Sep 26 2000 - 13:45:04 CDT