 Posted 12/10/2011 3:13:46 PM
|
|
|
|
I am trying to create a table using Oracle 10g Express. I am using the following code and am receiving the ORA-00903 error.
create table Item_Ordered (product_ID INTEGER NOT NULL, Order_ID INTEGER NOT NULL, Quantity INTEGER, PRIMARY KEY (Product_ID, Order_ID), FOREIGN KEY (Product_ID) REFERENCES Product(Product_ID), FOREIGN KEY (Order_ID) REFERENCES Order (Order_ID));
I have tried taking out the underscore but it still gives me an error. I have already created the Product and Order tables in which the foreign keys are referencing with no problem. Does anyone have any suggestions about how to fix this?
Thanks.
Matt
|
|
|
|