question

ghfk avatar image
ghfk asked

I'm a beginner. I need your help

CREATE TABLE productItem ( itemID numeric(4) PRIMARY KEY, barCode varchar(20) NOT NULL, expirationDate date NOT NULL, productCode numeric(4) NOT NULL, orderLineID numeric(4), CONSTRAINT productItem_product_fk FOREIGN KEY (productCode) references product (productCode) on DELETE CASCADE on UPDATE CASCADE, CONSTRAINT productItem_orderLine_fk FOREIGN KEY (orderLineID) references orderLine (orderLineID) on DELETE SET NULL on UPDATE CASCADE ) error report - ORA-00907: ¿¿¿ ¿¿¿ 00907. 00000 - "missing right parenthesis" Is there anyone can help me how to fix it correctly?
oracleerror
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Did you run the whole query, or did you select the query and then run only the selected code? If so, then did you fail to select line 15?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.