Re: using two databases with one SQL statement

From: <moerkd_at_my-deja.com>
Date: Fri, 10 Dec 1999 20:46:27 GMT
Message-ID: <82ror3$fhl$1@nnrp1.deja.com>

In article
<3850d5a4.147253469_at_news.cs.tu-berlin.de>, djg_at_cs.tu-berlin.de (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
>

Hallo Dirk,

to get informations from two different databases, you can use a database Link.
With that Link you can connect to database A, create the Link to database B. With that Link you can select from tables in Database A and Database B. To create a databse link you need the privilege create database link. May be you'll have to ask your DBA for the privilege. Any more questions? Post it.

see you Detlev

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 14:46:27 CST