How to Compare Two Records?

From: RK <rekaben_at_yahoo.com>
Date: 27 Jan 2006 06:03:27 -0800
Message-ID: <1138370607.179618.85220@g47g2000cwa.googlegroups.com>

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. Received on Fri Jan 27 2006 - 08:03:27 CST