Re: using two databases with one SQL statement

yes, it is.

The required object is a DB LINK.

a DBLINK allows you to reference objects in a remote oracle instance,

select ..... from
table_in_current_db,
table_in_remote_db_at_dblink_to_remote_db;

When creating a dblink you give it a user and a password, be sure that this user is allowed to operate on the object you reference.

Dirk Gómez ha scritto nel messaggio
<3850d5a4.147253469_at_news.cs.tu-berlin.de>...
>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 Sun Dec 12 1999 - 08:08:28 CST