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 -> Join Table Across Database

Join Table Across Database

From: Shinya Koizumi <d_at_d.com>
Date: Wed, 26 Apr 2006 23:00:48 GMT
Message-ID: <AYS3g.1894$o81.514@edtnps90>


Is there any service in oracle to join the remote table realtime( each table located in the different DB and different network)?

Location A has information about the customer information, Location B has information about the purchase info( number of books how much they spend ), and Location C has information about books( author, title, opinions on the book ).
We want to join these three tables and search on the joined table. Retrieved data should be updated each search.

Shinya Received on Wed Apr 26 2006 - 18:00:48 CDT

Original text of this message

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