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

RMAN-04006: error from auxiliary database: string

1 Answers  


ORA-27141: invalid process ID

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-25181: missing ON keyword for NESTED INDEX

1 Answers  


ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string

2 Answers  


ORA-09787: sllfop: unrecognizable processing option, incorrect format.

1 Answers  


RMAN-05011: auxiliary instance must be in nomount state for TSPITR

1 Answers  


ORA-26666: cannot alter STREAMS process string

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  


ORA-29298: Character set mismatch

1 Answers  


ORA-30941: Cannot specify empty URI for non-default namespace 'string'

1 Answers  


ORA-02855: Number of requests is less than the number of slaves

1 Answers  


Categories