CREATE TABLE IndustrialUnit (
UnitId NUMBER (7,2) PRIMARY KEY,
Location_place VARCHAR(50),
Country VARCHAR (50),
FOREIGN KEY (ProdId) REFERENCES Production(ProdId)
);
When I try to set the FOREIGN KEY, the following error occurs: ORA-00904: "PRODID": Invalid identifier.