Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to query between 2 remote databases

Re: how to query between 2 remote databases

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 02 Jul 2003 16:40:01 GMT
Message-ID: <MPG.196caabd38383f179897e2@news.la.sbcglobal.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US