Create Table Maintenance_Record( MaintenanceID int NOT NULL, Description_of_Maintenance VarChar2(40) NOT NULL, Date_of_Maintenance Date NOT NULL, constraint MAINTENANCE_RECORD_PK PRIMARY KEY...


Create Table Maintenance_Record(
MaintenanceID int NOT NULL,
Description_of_Maintenance VarChar2(40) NOT NULL,
Date_of_Maintenance Date NOT NULL,
constraint MAINTENANCE_RECORD_PK PRIMARY KEY (MaintenanceID),
constraint MAINTENANCE_RECORD_EMPLOYEE_FK FOREIGN KEY (EmployeeID)
REFERENCES EMPLOYEE(EmployeeID)
ON UPDATE NO ACTION
ON DELETE NO ACTION
);



Error report -
ORA-00904: "EMPLOYEEID": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:

*Action:



I am trying to create a table for Maintenance Record and I could not get it to work as there is an error saying employeeID is an invalid identifier. i  want to declare employeeID as a foreign key in the table but at the (ON UPDATE NO ACTION ON DELETE NO ACTION) part, the UPDATE is being underlined with the syntax error (Partially Recognized rules). Please help!



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here