Re: Data Comparsion with PL/SQL

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Sun, 13 Feb 2000 18:14:26 GMT
Message-ID: <8ED979931dlm@206.141.192.241>

stuirvineNOstSPAM_at_hotmail.com.invalid (stuarti) wrote in <217b5268.8823c167_at_usw-ex0101-007.remarq.com>:

>I have to compare a row from one table to a row in another table
>( with the same structure) I need to determin what fields have
>changed. Does anybody and any suggestions ???? I was going to
>do a field by field comparsion. - what is the most efficient way
>to do this???

same structure? if most of the rows are the same, then perform: select * from A minus select * from B union all
(select * from B minus select * from A)

this gives you rows added to either a A or B, and all rows which differ. --
dave mausner Received on Sun Feb 13 2000 - 12:14:26 CST