文档解释
ORA-32486: unsupported operation in recursive branch of recursive WITH clause
Cause: The recursive component of the UNION ALL in a recursive WITH clause element used an operation that was currently not supported. The following should not be used in the recursive branch of the UNION ALL operation: GROUP BY, DISTINCT, MODEL, grouping sets, CONNECT BY, window functions, HAVING, aggregate functions.
Action: Rewrite the query without the unsupported operation.
ORA-32486: unsupported operation in recursive branch of recursive WITH clause:这个错误指示用户尝试执行递归WITh子句中的一项不支持的操作,即在查询的相同端中执行不同的操作,这是不允许的。
官方解释
常见案例
一般处理方法及步骤
1、检查查询是否对递归WITh子句中的相同端执行不同的操作;
2、如果存在不一致的地方,尝试更改递归WITh子句来执行统一的操作;
3、重新尝试查询,看看是否能够正确执行。