Re: Q:PL/SQL over 2 databases

database link

is used to connect to different databases than the one you are connected.

SQL> CREATE DATABASE LINK production_dblink CONNECT TO scott IDENTIFIED BY tiger USING tns:production.world;

SQL> SELECT * FROM sometable_at_production_dblink;

look up the correct syntax for the create database link command.

Ralf Bender <Ralf.Bender_at_wolnet.de> wrote:

> Hallo *.*
>
> did somebody know, how to select data from one database in my actual
> database
> in pl/sql ?
>
> bye
> Ralf
> mailto:Ralf.Bender_at_wolnet.de
>
>

--
joebrown
@leading.net Received on Fri Oct 02 1998 - 08:23:59 CDT