Re: How to Compare Two Records?

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).

  HTH,
   ed Received on Fri Jan 27 2006 - 12:11:02 CST