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-00031: session marked for kill

1 Answers  


EXP-00034: error on rowid: file# number block# number slot# number

1 Answers  


QSM-02052: subquery using a select list in mv

1 Answers  


RMAN-03031: this option of set command needs to be used inside a run block

1 Answers  


ORA-19593: datafile number string already included as string

1 Answers  






ORA-23386: replication parallel push cannot create slave processes

1 Answers  


ORA-03283: specified datafile string does not exist

1 Answers  


TNS-12649: Unknown encryption or data integrity algorithm

1 Answers  


ORA-06700: TLI Driver: incorrect message type from host

1 Answers  


ORA-09264: sptpa: error flagging process

1 Answers  


ORA-00402: database changes by release string cannot be used by release string

1 Answers  


SQL-02135: Unable to initialize date format using supplied mask

1 Answers  


Categories