Tell me more ×  I have a trouble querying view in Oracle.  Here
is the view (my_cool_view) definition:    FROM mview1 JOIN
mview2 USING(col_id)   where mview1 and mview2 is materialized
views. I can't access to definition of this materialized views.
I've tried this query:  select r.title from my_cool_view r;  and
got ORA-00918: column ambiguously defined error. I got this
error for subset of columns in my_cool_view.  If I run this
query:  select * from my_cool_view;  all works fine.  You are
asking about desc my_cool_view in comments, sorry I can't
provide schema information because it's confidential. The only I
can say it contains about 80 columns, and only one (col_id)
don't cause above error.  Do you have any ideas what is the case
and how to fix it?  Thanks in advance.  Sorry for misled you,
the first version of question was too bad.  share|improve this
question you propably have column title defined twice in your
view. Could you add description of it? ("desc my_cool_view" in
SQL*Plus) –  Petr Prib