Re: Unique Key Constraint

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

When oracle lets you create more than one unique key on a table then obviously you can. There's only one primary key allowed per table but multiple unique keys. Received on Fri Jun 23 2006 - 10:46:38 CDT