+ 1

Error help

I write this code but its give me error Code : CREATE TABLE PRINT ( NUM_CUS char (20) not null, NUM_ORD char (20) not null, NUM_PHO char (20) not null, N_EXEMP decimal (20) not null, CONSTRAINT FK_CUS FOREIGN KEY ( NUM_CUS ) REFERENCES COSTUMER ( NUM_CUS ), CONSTRAINT FK_ORD FOREIGN KEY ( NUM_ORD ) REFERENCES ORDERE ( NUM_ORD ), CONSTRAINT FK_PHO FOREIGN KEY ( NUM_PHO ) REFERENCES PHOTO (NUM_PHO), CONSTRAINT PK PRIMARY KEY (NUM_CUS, NUM_ORD, NUM_PHO) ); Error : ORA-00942: table or view does not exist

12th Nov 2021, 8:30 PM
STOP
STOP - avatar
1 Réponse
0
It is likely due to misspelling of CUSTOMER as COSTUMER.
13th Nov 2021, 8:55 AM
Brian
Brian - avatar