Oracle Error ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list

Oracle Error Message

ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list

Reason for the Error

The SEARCH clause for a recursive WITH query specified a sequence column that was already listed in the column alias list for the WITH clause query name.

Solution

Specify a different name for the sequence column for the SEARCH clause or remove the name from the column alias list.