Re: connecting to two different instances from a ORA PL/SQL procedure

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Mon, 1 Dec 2003 05:10:52 -0600
Message-ID: <5iFyb.8630$Qc.2554@bignews5.bellsouth.net>

Within PlSql, this Sql will compare 2 tables (with same columns) in 2 databases using a db link ...

select * from mytable
minus
select * from mytable_at_otherdb
union all
select * from mytable_at_otherdb
minus
select * from mytable ;

The output would need work if you do find differences...

-- 
"Jon" <aaa_at_bbb.ccc> wrote in message news:bqf3un$31a$1_at_unbe.sarenet.es...


> From a PL/SQL block, I need to connect to two different ORA instances in

> order

> to compare data contained in two tables, one in each of the instances ...

> ¿is

> is possible?

>

>

Received on Mon Dec 01 2003 - 05:10:52 CST