Oracle Error PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

Oracle Error Message

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

Reason for the Error

A cursor was declared with a SELECT statement that contains duplicate column names. Such references are ambiguous.

Solution

Replace the duplicate column name in the select list with an alias.