ORA-00960: ambiguous column naming in select list

Question Posted / guest

2 Answers
12167 Views
I also Faced
E-Mail Answers

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-28528: Heterogeneous Services datatype conversion error

1 Answers

ORA-13836: invalid attribute value specified

1 Answers

DRG-10579: must provide text query criteria

1 Answers

ORA-32103: error from OCI call

1 Answers

ORA-10618: Operation not allowed on this segment

1 Answers

RMAN-03011: Recovery Manager: Release string string

1 Answers

ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string

1 Answers

TNS-04012: Unable to start Oracle Connection Manager instance.

1 Answers

DRG-10847: catsearch requires prefix index for this type of queries

1 Answers

ORA-09927: Unable to set label of server

1 Answers

ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'

1 Answers

RMAN-11004: format requires %%c when duplexing

1 Answers

For more Oracle Errors Interview Questions Click Here