Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Heterogeneous Join
Via database links.
Select ......
From table1_at_db1, table2_at_db2, .....
Where table1.column1 = table2.column2 ....
"Mark A. Richman" wrote:
> How do I set up a heterogeneous join? That is, query multiple databases
> simultaneously using a join clause? Is this possible via JDBC?
>
> Thanks.
>
> --
> Mark A. Richman
> Empire Software, Inc.
> Expert Software Development & Consulting
>
> + Internet/Intranet/Extranet
> + E-Commerce & B2B
> + Java, C/C++, Visual Basic
> + XML, SOAP, and Web Services
> + Linux & Open-Source Solutions
> + Database Applications
> + ...and MUCH more!
>
> http://www.empsoft.com
Received on Wed Apr 25 2001 - 20:56:26 CDT