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

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


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), -- herenoofseats number(4),price number(4),doj varchar2(10))


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))