Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02260: table can have only one primary key

Muhammad Salman RafiqueNov 16 2015 — edited Nov 16 2015

CREATE TABLE Invoice_Deatil

(

  Invoice# NUMBER PRIMARY KEY REFERENCES Invoice(Invoice#),

  Prod# NUMBER PRIMARY KEY REFERENCES Product(Prod#),

  Qty_Ordered NUMBER CHECK(Qty_Ordered BETWEEN 50 AND 5000)

  );

This post has been answered by aJohny on Nov 16 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2015
Added on Nov 16 2015
24 comments
19,928 views