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_at_posting.google.com>
Date: 14 Feb 2002 02:40:10 -0800
Message-ID: <a20d28ee.0202140240.3f2043c3_at_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 - 11:40:10 CET