Re: Unique indexes with null columns

From: Pankaj Behl <pbehl_at_hotmail.com>
Date: Tue, 26 Sep 2000 20:47:10 GMT
Message-Id: <10631.117913@fatcity.com>

Yes it is possible . Let the colums be nulls allowed in the table definition and then create the unique index as follows;

CREATE UNIQUE INDEX XYZ ON ABC
(

       W                      ASC,
       E             ASC,
      F                      ASC,
       G                  ASC,
       I               ASC,
       K                 ASC,
       L                 ASC,
       M               ASC,
       N              ASC

)
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1)
TABLESPACE TEST;
From: cemail_at_sprintmail.com
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Unique indexes with null columns Date: Tue, 26 Sep 2000 09:20:45 -0800

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

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at

Received on Tue Sep 26 2000 - 15:47:10 CDT