ORA-00960: ambiguous column naming in select list

Answers were Sorted based on User's Feedback



ORA-00960: ambiguous column naming in select list..

Answer / guest

Cause: A column name in the order-by list matches more than
one select list columns.

Action: Remove duplicate column naming in select list.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

ORA-00960: ambiguous column naming in select list..

Answer / bastian

There are more than one same named columns in selected
list,find out the same named columns,and rename the other
columns.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31209: DBMS_LDAP: PL/SQL - LDAP count_entry error.

1 Answers  


ORA-24270: a row already exists in the string table for these parameters

1 Answers  


ORA-32820: subscriber queue and exception queue must use same message system link

1 Answers  


ORA-36681: (XSDPART19) Partitions string and string are out of order.

1 Answers  


ORA-02371: Loader must be at least version string.string.string.string.string for direct path

1 Answers  






ORA-04007: MINVALUE cannot be made to exceed the current value

1 Answers  


ORA-00327: log string of thread string, physical size string less than needed string

1 Answers  


SQL-02151: Invalid host variable for exact numeric SET statement item

1 Answers  


ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 Answers  


ORA-16642: db_unique_name mismatch

1 Answers  


DRG-10200: invalid server personality mask: string

1 Answers  


TNS-12504: TNS:listener was not given the SID in CONNECT_DATA

1 Answers  


Categories