Re: using two databases with one SQL statement

Hi

Create a database link in database_a that connect to database_b.

Miklos

"Dirk Gómez" wrote:

> Hullo,
>
> is it possible to work with two Oracle databases with one SQL
> statement. Something like this:
>
> Select * from <database_a>, <database_b> where
> <database_a>.table_a.field1= <database_b> .table_b.field3
>
> cheers Dirk
Received on Fri Dec 10 1999 - 07:26:22 CST