Oracle Error ORA-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

Oracle Error Message

ORA-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

Reason for the Error

The CYCLE clause for a recursive WITH query specified a cycle mark column that was already listed in the column alias list for the WITH clause query name.

Solution

Specify a different name for the cycle mark column for the CYCLE clause or remove the name from the column alias list.