In this post, you’ll learn more about the Oracle ErrorPLS-00402: alias required in SELECT list of cursor to avoid duplicate column names with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names
Reason for the Error PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names
A cursor was declared with a SELECT statement that contains duplicate column names. Such references are ambiguous.
How to fix the Error PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names ?
You can fix this error in Oracle by following the below steps
Replace the duplicate column name in the select list with an alias.