Invalid SQL identifier - Oracle

Asked

Viewed 5,710 times

1

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 define the FOREIGN KEY the following error appears: ORA-00904: "PRODID": invalid identifier.

sql

1 answer

2

vc did not create the Prodid column in this table (Industrialunit). also this column should be of the same type and not null in the Production table. check out.

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.