Compare data in two tables help Please ??

From: Mujahid Hamid <mujahid_at_pharmco.demon.co.uk>
Date: Mon, 3 Apr 2000 22:57:14 +0100
Message-ID: <954798834.27509.0.nnrp-06.c2de4f17@news.demon.co.uk>

Hi All,

I want to compare data in two tables and find out updated and inserted record by comparing the two tables.
(I do not want to use triggers)
I can get the new record by using the primary keys, but updated rows are a problem, I want to be able to compare all the columns in one row in one table to the all columns of the other table.

Can this be done using PL/SQL ?

These table are also available in flat CSV file, can I use Unix diff on these and get the same result.

Please please help me, I will very much appreciate you help if you have done this and have scripts which may of use to me ..

With Thanks

Mujahid Received on Mon Apr 03 2000 - 16:57:14 CDT