DIFF? How to compare 2 rows of data to determine which cols differ?
464589Sep 6 2007 — edited Dec 3 2007Hi all,
An age-old question, I suspect, so please point me at resources if they already exist for this...
My app is comparing 2 occurrences of the same data, where one will have changed. I've had success generating the MINUS queries (both ways) that result in an "output table" with only those differing rows in it. Now I just want to wrap it up by actually determining which column values differ. There seem to be various utilities out there (came across sqldiff at sourceforge.net, etc) but I'm looking to code it in my PL/SQL code. So - is there some easy way to do this? Currently thinking of writing code to manually read/compare each column for each pair of rows, but gotta beleive there's a better way...
Thanks for any help/ideas!
Jim Carter