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

Answers were Sorted based on User's Feedback



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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    3 Yes 3 No

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

Answer / chimbu

Remove the same column name in cusor query.

ex:

select a1,a2,a1 from table1;

Here their are two columns named a1.

Remove it and you wont get the error

Is This Answer Correct ?    4 Yes 8 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19615: some files not found in backup set

1 Answers  


ORA-02257: maximum number of columns exceeded

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


ORA-29269: HTTP server error string

1 Answers  


ORA-02045: too many local sessions participating in global transaction

1 Answers  






ORA-31431: all source tables must belong to the synchronous change set

1 Answers  


LPX-00007: unexpected end-of-file encountered

1 Answers  


CLSS-02200: Received node deletion request for active node string.

1 Answers  


ORA-01273: STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher

1 Answers  


ORA-00127: dispatcher string does not exist

1 Answers  


DRG-12218: section group name missing

1 Answers  


ORA-26505: unexpected internal null

1 Answers  


Categories