Oracle Error ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

Oracle Error Message

ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

Reason for the Error

A SEARCH clause and a CYCLE clause was specified for a recursive WITH query, but the sequence column of the SEARCH clause matched the cycle mark column of the CYCLE clause.

Solution

Change either the sequence column or the cycle mark column so that they no longer match.