oracle - Creating SQL table -
i trying create below table oracle telling me keyword missing. have looked @ code cant see problem. please help
create table lecture (lectureid integer not null, startdate date not null, starttime time not null, endtime time not null, ticketid integer not null, primary key (lectureid), foreign key (ticketid) references ticket(ticketid) on delete restrict on update cascade);
this error code getting
ora-00905: missing keyword
there no "on update cascade" in oracle
sql oracle ddl
No comments:
Post a Comment