aiaiDBA

加微信获取免费职业规划+学习资料，了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements

ORA-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements
Cause: A SEARCH or a CYCLE clause was specified for a WITH clause element that was not recursive.
Action: Remove the SEARCH or CYCLE clause, or add recursion to the WITH clause element.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-32480：SEARCH和CYCLE子句只能为递归WITH子句元素指定,
.原因：为不是递归的WITH子句元素指定了SEARCH或CYCLE子句。,
.操作：删除SEARCH或CYCLE子句，或向WITH子句元素添加递归。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，677 浏览
  • 慧慧 提出于 2018-08-30 16:50

相似问题