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!

select from multiple tables through dblink

citicbjOct 3 2007 — edited Oct 3 2007

I am seeking help. Can I select multiple tables through a dblink from a remote database? I tried, it seems it always return ORA-00933 error. code like this:

select A.ID, B.CODE, C.TYPE_DESC
from TABLE_ONE A@db_link , TABLE_TWO B@db_link, TABLE_THREE C@db_link;
where A.ID = B.ID
and B.CODE = C.CODE

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2007

Added on Oct 3 2007

2 comments

1,502 views