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: Heterogeneous Join

Re: Heterogeneous Join

From: Nils O. Selåsdal <noselasd_at_frisurf.no>
Date: Thu, 26 Apr 2001 12:11:30 +0200
Message-ID: <evSF6.531$Ty6.8543@news1.oke.nextra.no>

"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

Original text of this message

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