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!
![Q: [ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on…A: A relational database contains tables. Tables are also known as relations and they contain rows and…](/questions-and-answers/slide-15-.png-q1.-please-write-sql-codes-to-create-below-member-database-table-based-on-the-previous/3b4446fb-5348-4dbb-944d-a99326b9259f){kind=link}
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!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
