Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to query between 2 remote databases
kiran was kind enough to write:
> How to query on two tables that are on two different remote database
> with a join.
>
> s *
> f tb1_at_uid/pass_at_db1.world a, tb2_at_uid/pass_at_db2.world b
> w a.col1 = b.col2
>
> but this does not work, any idea ?
>
> Thanks
>
>
I think you need to define "does not work" since this pattern should work except for the fact that it won't know what the star means -- all the columns from tb1 or tb2?
-- [:%s/Karsten Farrell/Oracle DBA/g]Received on Wed Jul 02 2003 - 11:40:01 CDT
![]() |
![]() |