Top "Ora-00918" questions

ORA-00918: column ambiguously defined in SELECT *

Getting ORA-00918: column ambiguously defined: running this SQL: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER …

sql oracle ora-00918

SQL: How to find duplicates based on two fields?

I have rows in an Oracle database table which should be unique for a combination of two fields but the …

sql oracle unique unique-constraint ora-00918

ORA-00918: column ambiguously defined: how to find the column

I'm getting the classic error: ORA-00918: column ambiguously defined Usually, I know how to solve it but my problem now …

oracle ora-00918

Why doesn't Oracle raise "ORA-00918: column ambiguously defined" for this query?

I've just come across a strange behaviour in Oracle where I would expect ORA-00918 to be raised, but isn't. Take …

sql oracle oracle10g oracle11g ora-00918

Mixing "USING" and "ON" in Oracle ANSI join

I wrote an Oracle SQL expression like this: SELECT ... FROM mc_current_view a JOIN account_master am USING (account_…

sql oracle ora-00918

FULL OUTER JOIN with two subselects gives "ORA-00918: column ambiguously defined"

both Subselects runs fine standalone. But I wish to join them togehter, which always gives "ORA-00918: column ambiguously defined". I …

sql oracle join subquery ora-00918