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-01271: Unable to create new file name for file string

1 Answers  


RMAN-08024: channel string: restore complete

1 Answers  


SQL*Loader-00640: Variable length field was truncated.

1 Answers  


TNS-00090: * Interchange - will ask the Interchange

1 Answers  


NNL-00830: Delete requests received: number

1 Answers  


NID-00601: Internal Error - [number] [string] [number] [number]

1 Answers  


IMP-00061: Warning: Object type "string"."string" already exists with a different identifier

1 Answers  


PCC-00088: User defined type identifier expected

1 Answers  


PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records

1 Answers  


ORA-30205: invalid Character set

1 Answers  


ORA-36212: (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.

1 Answers  


ORA-25156: old style outer join (+) cannot be used with ANSI joins

1 Answers  


Categories