Re: Unique Key Constraint

From: Anurag Varma <avoracle_at_gmail.com>
Date: 23 Jun 2006 08:41:58 -0700
Message-ID: <1151077318.345454.304810@r2g2000cwb.googlegroups.com>

Khurram wrote:
> hi
>
> I read the following Unique key restriction
>
>
> -A table or view can have only one unique key.
>
> From
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses3a.htm
>
> But when i create more then one unique key it let me create is document
> pointing me wrong
> or i am getting wrong inference?
>
> SQL> DROP TABLE t;
>
> Table dropped.
>
> SQL> CREATE TABLE t (a NUMBER UNIQUE,b NUMBER UNIQUE);
>
> Table created.
>
> Khurram

Don't believe everything you read :) . Must be a doco bug where they copy pasted
the restrictions from the PK Restrictions.

Anurag Received on Fri Jun 23 2006 - 10:41:58 CDT