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 -> can you join table from oracle and from SQL server?

can you join table from oracle and from SQL server?

From: ji <gudy_at_nospam.com>
Date: Thu, 06 Oct 2005 05:33:51 GMT
Message-ID: <3H21f.1164$S4.4@edtnps84>


Any one come across any tool or application can search on two different database ( one is oracle and the other is sql server and you use joined to make a virtual table )?

Say I have smilar to the following table

        tableA.Oracle

isbn    title          author
1        book1        authorA
2        book2        authorB
3        book3        authorC
4        book4        authorD

tableB.SQL

isbn price

1        $12
2        $10
3        $15
4        $1

When you search all you go to Oracle to search all first and SQL to search all combine
the search result with isbn (pk) you construct the virtual search result.

Have any seen something like this?

J.J Received on Thu Oct 06 2005 - 00:33:51 CDT

Original text of this message

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