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-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object

1 Answers  


ORA-01343: LogMiner encountered corruption in the logstream

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


ORA-09858: sfngat: the input file name is not in the OMF format

1 Answers  


ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow <index name>

1 Answers  






ORA-27502: IPC error deleting OSD context

1 Answers  


ORA-32814: propagation schedule string does not exist

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


DRG-50905: invalid score threshold string

1 Answers  


ORA-09761: pw_destroyPorts: server call pws_stop_instance failed.

1 Answers  


TNS-12596: TNS:internal inconsistency

1 Answers  


Categories