Wednesday 15 June 2011

oracle - Creating SQL table -



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