Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ROWID mismatch

656310Jun 3 2013 — edited Jun 4 2013
Hallo,

please could someone explain to me, what is the REASON for following Oracle behaviour?

SQL:
select '1' from dual a
left join (
select c.dummy
--, b.rowid
from dual b
join dual c
on b.dummy = c.dummy) d
on a.dummy = d.dummy;

If I uncomment column b.rowid Oracle returns error : ORA-00918: column ambiguously defined.
If I put alias ( b.rowid x) it works, but anyway I would like to know the cause.

Note: SQL above is simplified and reproducible version of our application SQL code.

Thank you. Filip
This post has been answered by Jonathan Lewis on Jun 3 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2013
Added on Jun 3 2013
18 comments
3,030 views