This content has been marked as final. Show 3 replies
984896 wrote:The next-to-last line above has "foreign" mis-spelled. Change it to
i go this error :
this is the code
ERROR at line 10: ORA-00907: missing right parenthesis
create table LIGNE_COMMANDE (NumProd number(10), Prix number(11,2), Qtecom number(9), NumCom number(7), constraint pk_LICOM primary key(NumProd, NumCom), constraint ref_CLI foreign key(NumCli) references CLIENT(NumCli), constraint ref_PROD foreing key(NumProd) references PRODUIT(NumProd) );
Also, you have a constraint for the column called NumCli, but no such column.
foreign key(NumProd) references PRODUIT(NumProd)
there is no parenthesis missing.No, that error message occurs for all kinds of syntax errors, including mis-spelled key words. It would be more correct if the message read "Syntax error, such as missing right parenthesis". Missing right parenthesis might be the single most common cause of the error message, but it doesn't account for 50% of the occurrences, or anywhere near 50%.
i clicked by mistake, sorry
oh thank you, i'm new in sql