Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: unique index on upper

Re: unique index on upper

From: XXX <xxx_at_hotsex.com>
Date: Sun, 3 Dec 2000 17:53:55 +0200
Message-ID: <90dq7e$9em$1@news.netvision.net.il>

Hi,
When creating a primary key constraint on a column, you create a unique index on that column.
once you create the primary key you cannot create another index on that column.
you can create a unique index on a column regardless of the primary key constraint in the table.
r. Received on Sun Dec 03 2000 - 09:53:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US