ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches

ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches
Cause: A WITH clause query referred to itself (recursive) indirectly, such as through a subquery or view.
Action: Rewrite the recursive WITH clause query to refer to itself directly in the FROM clause of one of the UNION ALL branches.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-32042：recursive WITH子句必须直接在UNION ALL分支中引用自身,
.原因： WITH子句查询本身（递归）间接引用，例如通过子查询或视图。,
.操作：重写递归WITH子句查询以直接在UNION ALL分支的FROM子句中引用自身。,
.

aiaiDBA

13718043309

010-86462881

ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches

1 个回答

相似问题