Welcome to the forum!
Hi,friends i created tables as above when i creating 'ORDERS' table the error will fir as "ORA-02270: no matching unique or primary key for this column-list".
can any body solve this issue.
No - not in this forum. This forum is ONLY for sql developer questions like the title says.
Mark this question ANSWERED and repost it in the SQL and PL/SQL forum SQL and PL/SQL
When you repost provide your 4 digit Oracle version.
CONSTRAINT FK2_ORDERS FOREIGN KEY (ITEM_NUM) REFERENCES ITEM(ITEM_NUM));
You can't reference ITEM.ITEM_NUM because, as the exception says, there is 'no matching unique or primary key for this column'
The primary key on the item table contains two columns.
CONSTRAINT PK_ITEM PRIMARY KEY(ITEM_NUM,TYPE));