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 parentheses
The expression foreign keyis redundant (read: incorrect). The syntax is just to add references:
foreign key
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))
change yout instruction CREATE TABLEas below
CREATE TABLE
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))
Source: https://habr.com/ru/post/1598341/More articles:Visual Studio Team Services says "PowerShell Error", although it is not - gitJava SSO windows AD spring4 - Invalid header header: - javaShift (update) unique column values in PostgreSQL - sql-updateIOS Login Button for IOS - iosДвоичная трехмерная нечеткая матрица в matlab - algorithmSymfony 2: how to send an email using Swiftmailer - phpjava.lang.VerifyError creates a gradle task with kotlin - javapython opencv cv2.cv.CV_CAP_PROP_FRAME_COUNT get invalid numbers - pythonDSL Extraction Class Field Name - scalaAngular app / widget on multiple web pages - javascriptAll Articles