CODEWITHSUNDEEP
sqloracle-database
SKT T1 Faker
SKT T1 Faker

Reputation: 25

Oracle error when creating table

CREATE TABLE Driver(
Driver_ID number(10) Primary key,
DriverFname varchar(15),
DriverLname varchar(15),
Train_ID number(10) Foreign key References
Train(Train_ID)
);

I get this error ORA-00907: missing right parenthesis when I try to run it

Upvotes: 0

Views: 54

Answers (1)

Trent
Trent

Reputation: 86

take out the Foreign key - you don't need that. just Train_ID number(10) References Train(Train_ID)

so run this:

CREATE TABLE Driver(
Driver_ID number(10) Primary key,
DriverFname varchar(15),
DriverLname varchar(15),
Train_ID number(10)  References
Train(Train_ID)
);

Upvotes: 1

Related Questions