Re: table data diff
Date: Fri, 15 Feb 2002 08:08:30 +0530
Message-ID: <M5%a8.40$zU5.424_at_inet-nntp1.oracle.com>
Thanks,
That's exactly what I wanted.
and I have stopped cross/ multiposting
Sunil.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news: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 Fri Feb 15 2002 - 03:38:30 CET