Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> can you join table from oracle and from SQL server?
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
![]() |
![]() |