Re: table data diff

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 14 Feb 2002 02:40:10 -0800
Message-ID: <a20d28ee.0202140240.3f2043c3@posting.google.com>

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:<7VHa8.51$EC3.627_at_inet-nntp1.oracle.com>...
> I am looking for a utility which can compare data differences between two
> tables ( having the same structure and pk ) in two different schemas. Does
> any one know of a utility that can do this or me.
>
>
> Thanks in advance.
> Sunil.

the utility is called .................... SQL

select *
from tableA
minus
select *
from tableB

Please do not cross- or multipost.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 14 2002 - 04:40:10 CST