Re: how to query between 2 remote databases

I do have a dblink between the two remote databases,which I am using in my query userid/ password followed by dblink

Thanks
Kiran

Tim X wrote:
>>>>>> "kiran" == kiran <kiran.news.invalid_at_web2news.net> writes:
>
> kiran> How to query on two tables that are on two different remote
> kiran> database with a join.
>
> kiran> s * f tb1_at_uid/pass_at_db1.world a, tb2_at_uid/pass_at_db2.world b w
> kiran> a.col1 = b.col2
>
> kiran> but this does not work, any idea ?
>
> kiran> Thanks
>
> Read up about database links. You need to create a db link and then
> use the syntax
> select ....
> from table_at_dblink_name
> ....

-- 
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.oracle.server