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

Oracle Error Message

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

Reason for the Error

A WITH clause query referred to itself (recursive) but did not use a UNION ALL operation in its definition query.

Solution

Rewrite the recursive WITH clause query to use a UNION ALL operation.