Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |