Comparing backup database with current database

From: Nick Bowler <Nick_Bowler_at_amsinc.com>
Date: Mon, 16 Apr 2001 13:40:01 -0400
Message-ID: <9bfavi$5js$1@bob.news.rcn.net>

I have two tables - A and B. B is a copy of A made yesterday. The tables are such that rows are changed and added, never deleted. I need to determine the differences between these two tables. Determining rows added is easy. However, to determine rows that are different I have had to resort to building a query along the lines of

SELECT key
FROM A, B
WHERE A.key = B.key AND(

         A.field1 <> B.field1
   OR A.field2 <> B.field2
   OR A.field3 <> B.field3 ....);

Can anyone suggest a better way of determining if rows are different. Note: I am using Oracle 8.1.6. Received on Mon Apr 16 2001 - 12:40:01 CDT