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

In Sybase it's a bit slower and dirtier than this. I think you'll need to use a NOT EXISTS correlated subquery if Sybase is your RDBMS. The Sybase method is sort of relational calculus; the Oracle method is algebra.

Regards,
-Mike Bilhartz

Graham Thornton wrote in message <3630AE39.4245_at_ln.ssw.abbott.com.nospam>...
>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 Thu Oct 29 1998 - 00:00:00 CST