Oracle 允许哪种类型的循环依赖关系?
我正在创建测试用例,我需要涵盖循环依赖项。到目前为止,我已经能够创建两个表,使得表 A 具有到 B 的 FK,而 B 具有到 A 的 FK。
对象之间存在/允许哪些其他循环依赖项?我尝试在视图之间创建循环,但 Oracle 成功拒绝了这一点。
I am creating test cases and I need to cover circular dependencies. So far I have been able to create two tables such that Table A has a FK to B and B has a FK to A.
What other circular dependencies exist / are allowed between objects? I tried to create cycles between Views but Oracle successfully rejected that.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您可以推迟约束,以便在提交时而不是在 DML 时检查它们。这可能会带来一些可能性。
You can make constraints deferred, such that they are checked commit time rather than at DML time. That might open some possibilities.
包 pck_a 可以引用 pck_b,反之亦然。
查看
dba_dependency
以了解哪些内容引用了哪些内容。但是,测试用例应该测试什么?也许,有了这些知识,这里的人们可以给你更好的答案。
Package pck_a can reference pck_b and vice versa.
Take a look into
dba_dependencies
to see what what references what.But, what are the test cases supposed to test? Maybe, with that knowledge, people here could give you better answers.