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 ACTIONON DELETE NO ACTION);
Error report -ORA-00904: "EMPLOYEEID": invalid identifier00904. 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!
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here