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.

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.