Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: comparing 3 tables from 3 databases

Re: comparing 3 tables from 3 databases

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 11 Aug 2004 07:30:15 -0500
Message-ID: <uacx17tbo.fsf@standardandpoors.com>


On Tue, 10 Aug 2004, spedwards_at_x.qwest.net wrote:
> We have 3 databases. Each of these databases have a identical
> table. Each table has anywhere from 1400-1550 records. The
> data in these tables was supposed to be identical. But they
> aren't. So, I need to compare the table in each database to
> determine the exact differences of the data. Any suggestions
> on how to best complete this task would be greatly appreciated!

A series of "minus" queries should do the trick.

-- 
Galen Boyer
Received on Wed Aug 11 2004 - 07:30:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US