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.
The recursive member cannot contain any of the following elements:
・An aggregate function. However, analytic functions are permitted in the select list.
There are 2 documents.
Previous explains that "window functions" should not be used in the recursive branch.
Another explains that "analytic functions" permitted in the recursive branch.
My question is which is true ?:|
memo from To use "analytic function" at "recursive with clause"
Oracle 18.104.22.168 does not allows "analytic functions" can be used at "recursive with clause".
Oracle 22.214.171.124 allows "analytic functions" can be used at "recursive with clause".