sql - Error when adding foreign key constraint -


i trying alter table in oracle's sql*plus able create table using reserved word order using quotes. able add primary key constraint. when comes adding foreign key have error. researched doing wrong, can't find satisfactory answer. i'll appreciate help. thanks!

sql> alter table "order"   2  add constraint order_fk   3  foreign key(c_no)    4  references customer(c_no)   5  on delete restrict; on delete restrict           * error @ line 5: ora-00905: missing keyword 

oracle not support "restrict"

according oracle options are: (1) omitting on delete (2) on delete cascade , (3) on delete set null.

i believe omitting on delete closest on delete restrict.


Comments

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Socket.connect doesn't throw exception in Android -

SPSS keyboard combination alters encoding -