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

Paavo

Hi
Copy-pasting large snippets sounds like you could benefit of using editor instead?
It is possible to define editors like: emacs, vi, visual studio code.
For vcode:
--open terminal in vcode and use sqlcl and e file.sql and / commands and enjoy
define _EDITOR=code -w -r
rgrds Paavo
ps. have a look on @thatjeffsmith-oracle blogs e.g. http://www.thatjeffsmith.com/archive/2016/05/multiple-ways-to-edit-in-sqlcl/

AboMohammed

Thanks for your response.

I will definitely try it.

1 - 2
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,132 views