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 -> Unique Key Constraint

Unique Key Constraint

From: Khurram <oraware_at_gmail.com>
Date: 23 Jun 2006 08:34:05 -0700
Message-ID: <1151076845.672046.142370@y41g2000cwy.googlegroups.com>


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 Received on Fri Jun 23 2006 - 10:34:05 CDT

Original text of this message

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