ORA-32040: recursive WITH clause must use a UNION ALL operation

ORA-32040: recursive WITH clause must use a UNION ALL operation
Cause: A WITH clause query referred to itself (recursive) but did not use a UNION ALL operation in its definition query.
Action: Rewrite the recursive WITH clause query to use a UNION ALL operation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-32040：recursive WITH子句必须使用UNION ALL操作,
.原因： WITH子句查询引用自身（递归），但在其定义查询中未使用UNION ALL操作。,
.操作：重写递归WITH子句查询以使用UNION ALL操作。,
.

aiaiDBA

13718043309

010-86462881

ORA-32040: recursive WITH clause must use a UNION ALL operation

1 个回答

相似问题