在ON UPDATE上获取以下ORA-00907错误 [英] Getting an ORA - 00907 error on the following at ON UPDATE
本文介绍了在ON UPDATE上获取以下ORA-00907错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
实现我的oracle数据库时,在ON UPDATE的第8行上收到ORA-00907错误.它抱怨右括号,但是我在任何地方都看不到这个错误.我的问题是什么?
When implementing my oracle database I receive an ORA-00907 error on line 8 at ON UPDATE. Its complaining about right parenthesis but I don't see this error anywhere. whats my issue?
CREATE TABLE Result (
Rid number,
Hid number,
Jid number,
Jweight number(5),
Place number(3),
CONSTRAINT Result_PK PRIMARY KEY(Rid, Hid, Jid),
CONSTRAINT ResultRACE_FK FOREIGN KEY(Rid) REFERENCES Race(Rid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT ResultHORSE_FK FOREIGN KEY(Hid) REFERENCES Horse(Hid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT ResultJOCKEY_FK FOREIGN KEY(Jid) REFERENCES Jockey(Jid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT Jweight_Check CHECK(Jweight > 0 AND Jweight < 116))
推荐答案
Oracle RDBMS不支持ON UPDATE CASCADE
.
Oracle RDBMS does not support ON UPDATE CASCADE
.
这篇关于在ON UPDATE上获取以下ORA-00907错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文