How to fix the Oracle error ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches?

In this post, you’ll learn more about the Oracle ErrorORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

A WITH clause query referred to itself (recursive) indirectly, such as through a subquery or view.

How to fix the Error ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches ?

You can fix this error in Oracle by following the below steps

Rewrite the recursive WITH clause query to refer to itself directly in the FROM clause of one of the UNION ALL branches.