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: Primary Key ....

Re: Primary Key ....

From: SR <stefano_at_despammed.com>
Date: Sat, 12 Mar 2005 14:13:19 +0100
Message-ID: <eiz7hhzl4mkf$.1iv42j8b0uinv.dlg@40tude.net>


On 11 Mar 2005 20:40:15 -0800, Ariji Chatterjee wrote:

> Dear Faculties,
> Here I have created a table in two manner ..
> ===================================

In first scenario you have created a unique key, but it's not the primary, therefore the engine would still let you create an actual PK on that table while in the second scenario it would not. Of course both scenarios would lead to failure of an attempt to insert duplicate data in the table. You can have as many unique indexes as you like in a table but only one PK. Received on Sat Mar 12 2005 - 07:13:19 CST

Original text of this message

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