Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Heterogeneous Join
"Robert Klemme" <robert.klemme_at_myview.de> wrote in message news:3AE7CE36.BEED1659_at_myview.de...
Rich Woods schrieb:
>
> Via database links.
>
> Select ......
> From table1_at_db1, table2_at_db2, .....
> Where table1.column1 = table2.column2 ....
are you sure that this is supported by every JDBC driver? if not, can you state which driver does this?
A jdbc driver just sends the sql query, it doesnt analyze it...
If your DBMS supports it, the jdbc driver will also...unless its a really
really
crappy driver, that isnt jdbc conformant.(then it would fail other queries
also, not
just joins...)
Received on Thu Apr 26 2001 - 05:11:30 CDT