Re: Looking for a table difference (compare) utility.

mravichandran_at_hotmail.com wrote:
>
> Dear Netters,
>
> I know that a utility exists to compare the difference in 2 ASCII files (or 2
> copies of the same file, one of which is modified). I am looking for a
> utility to do the same for tables in a relational database.
>
> I will be making changes to an existing table.. modifying records not the
> table structure. i want to know whether any utility will compare the records
> of 2 tables and point out the one that are different.
>

A very quick and dirty method is:

select * from table1 minus select * from table2

• returns all rows from table1 that do not have an exact match in table2

like I said, it's quick and dirty - but maybe it's all you need?

Graham. Received on Fri Oct 23 1998 - 00:00:00 CDT