Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Unique Key Constraint
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