CODEWITHSUNDEEP
sqloracle-databaseforeign-keyssyntax-errorddl
vineet kumar
vineet kumar

Reputation: 41

I am getting this error ORA-00907: missing right parenthesis

create table passenger(pnr number(10) primary key,
trainnumber number(5) foreign key references train(trainnumber),
noofseats number(4),
price number(4),
doj varchar2(10))

ORA-00907: missing right parenthesis

Upvotes: 4

Views: 390

Answers (2)

Rahul
Rahul

Reputation: 77876

change yout CREATE TABLE statement to be like below

create table passenger(pnr number(10) primary key,
trainnumber number(5), 
noofseats number(4),
price number(4),
doj varchar2(10),
foreign key (trainnumber) references train(trainnumber))

Upvotes: 1

Mureinik
Mureinik

Reputation: 311228

The foreign key expression is redundant (read: wrong). The syntax is just to add references:

create table passenger(pnr number(10) primary key,
trainnumber number(5) references train(trainnumber), -- here
noofseats number(4),
price number(4),
doj varchar2(10))

Upvotes: 1

Related Questions