Question

sql语句有什么问题?提示ORA-00907: 缺少右括号

create table scc
( sno char(7),
cno char(8),
grade number,
primary key(sno,cno),
foreign key (sno) references student(sno)
on delete cascade
on update cascade,
foreign key(cno) references course(cno)
on delete cascade
on update cascade );

Answer 1

如果你是用的ORACLE的话，on update cascade是不支持的。只有ON DELETE CASCADE
和 DELETE SET NULL。

Answer 2

最后一句话，括号里面、cascade后面也该有个标点符号吧！