Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-25179: invalid PCTTHRESHOLD storage option value

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-38610: FI "string" name prefix is reserved for frequent itemset counting

1 Answers  


DRG-12303: cannot add more than 99 indexes to an index set

1 Answers  


PCC-00075: ":" expected before indicator variable

1 Answers  






NCR-03010: NCRO: Transfer callback error

1 Answers  


EXP-00005: all allowable logon attempts failed

1 Answers  


ORA-31455: nothing to ALTER

1 Answers  


ORA-19653: cannot switch to older file incarnation

1 Answers  


ORA-31470: asynchronous change tables must contain the RSID$ column

1 Answers  


ORA-12018: following error encountered during code generation for "string"."string"

1 Answers  


ORA-06919: CMX: error during write request (unknown event)

1 Answers  






Categories