Re: Compare data in two tables help Please ??

Yes, you can do this using PL/SQL, but have you considered using SQL*Plus?

The following will do what you want.

	SELECT * FROM Table_1
	MINUS
	SELECT * FROM Table_2;



>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/3/00, 4:57:14 PM, "Mujahid Hamid" <mujahid_at_pharmco.demon.co.uk> wrote regarding Compare data in two tables help Please ??:

> 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 - 23:14:48 CDT