Re: Connect to several database

From: Walter Dorninger <walter.dorninger_at_aon.at>
Date: 3 Jul 2002 11:04:37 -0700
Message-ID: <1dd1ddc8.0207031004.d7d8b17@posting.google.com>

Hmmm seems to me that you need to study the following topics in the oracle manuals:

(1) Databaselinks
(2) Views
(3) Unions (Select Statement)

I think you will make it with those three "magic" items ;-)

"Antoine GOURAUD" <agouraud_at_infovista.com> wrote in message news:<3d230906$0$24009$4d4eb98e_at_read.news.fr.uu.net>...
> Hi
> Here is our problem: we are looking for a tool (Oracle or an other one)
> allowing to get back the data resulting from some database having the same
> schema.
>
> for exemple a client will send an sql query to this tool, this tool will
> connect to more than one database and send the SQL query to those database.
> the result to the client will contain all the concatenation of the result
> for each elementary SQL Query.
>
> Thanks in advance for all suggestions.
>
> Antoine
Received on Wed Jul 03 2002 - 13:04:37 CDT