Re: How to Compare Two Records?

From: Ed Prochak <edprochak_at_gmail.com>
Date: 31 Jan 2006 10:07:31 -0800
Message-ID: <1138730851.058376.121630@g44g2000cwa.googlegroups.com>

RK wrote:
> Ed Prochak wrote:
> > RK wrote:
> > > Please help.
> > >
> > > How do I compare two records in SQL*Plus by each field pair?
> > >
> > > -- I have two tables with the same structure, but the records in the
> > > two tables may be the same and may be different. I can use minus to
> > > select the different records between the two tables, but how do I do to
> > > pick out which field of the different record(s) that make the
> > > difference? One table may have dozens of fields, and the differences
> > > may be to the thousands of records, and all fields could be different.
> > >
> > > Thanks.
> >
> > Looking for just a SQL solution??
> > there isn't an easy one. Would doing a minus on the PK and each field
> > work?
> > (ie a separate MINUS query for every non PK field)
> >
> > If there are a lot of fields, use the data dictionaly to create the
> > queries.
> >
> >
> > A solution outside SQL might be easier. PERL springs to mind as a
> > language for this. Or maybe LISP might be better? (I don't know LISP).
> >
> > ...

>
>

> By Perl/LISP, you meant to dump the table contents into files, and
> compres the two files?

yes.

>

> That is what I am doing right now. However just wish to learn if there
> is a way with Oracle tools / applications themselves.
>
> Thanks.

Thank Daniel, he answered you better than I did. Received on Tue Jan 31 2006 - 12:07:31 CST