Oracle Error Message
ORA-00960: ambiguous column naming in select list
Reason for the Error
A column name in the order-by list matches more than one select list columns.
Solution
Remove duplicate column naming in select list.
ORA-00960: ambiguous column naming in select list
A column name in the order-by list matches more than one select list columns.
Remove duplicate column naming in select list.