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.
