How to fix the Oracle error ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element?

In this post, you’ll learn more about the Oracle ErrorORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element

Reason for the Error ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element

The recursive component of the UNION ALL in a recursive WITH clause element referenced the recursive query name more than once. Only one reference to the recursive query name is allowed in the recursive branch of a recursive WITH clause element.

How to fix the Error ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element ?

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

Rewrite the query using only one reference to the recursive query name in the recursive branch of the recursive WITH clause element.