Oracle Error ORA-32483: duplicate name found in sort specification list for SEARCH clause of WITH clause

Oracle Error Message

ORA-32483: duplicate name found in sort specification list for SEARCH clause of WITH clause

Reason for the Error

A SEARCH clause was specified for a recursive query with a sort specification list which contained duplicate names.

Solution

Remove the duplicate names from the sort specification list of the SEARCH clause.