且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何通过检查或触发器实现ondelete限制

更新时间:2023-11-28 08:22:40

我觉得你误会了什么。如果在Oracle中创建外键约束,则默认操作是防止在存在子记录时在主表上删除。



例如,请查看: http://docs.oracle.com/cd/B19306_01/server.102/ b14200 / clauses002.htm#i1015699 [ ^ ]
I think you have misunderstood something. If you create a foreign key constraint in Oracle, the default action is to prevent a deletion on master table if child records exist.

For example, have a look at: http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm#i1015699[^]