How to fix the Oracle error ORA-32043: recursive WITH clause needs an initialization branch?

In this post, you’ll learn more about the Oracle ErrorORA-32043: recursive WITH clause needs an initialization branch with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-32043: recursive WITH clause needs an initialization branch

Reason for the Error ORA-32043: recursive WITH clause needs an initialization branch

A WITH clause query referred to itself (recursive) but did not have a branch in a UNION ALL with no references to itself (the initialization branch or anchor member).

How to fix the Error ORA-32043: recursive WITH clause needs an initialization branch ?

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

Rewrite the recursive WITH query to have a branch in a UNION ALL operation with no references to itself.