Compare Two Tables 1

[Michael42]

Hello All,

Would any of you have a script or technique you could share that compares two tables to ensure the data contained within them is identicle?

I would like to go a little further than a simple SELECT count(*).

Thanks,

Michael42

 

[Thargy]

Michael,

select * from table1
minus
select * from table 2;

Then,

select * from table2
minus
select * from table1;

will detect absent and surplus records.

Regards

Tharg


Grinding away at things Oracular

 

[Michael42]

thargtheslayer,

Thanks for posting. It is simple and very effective!

Thanks,

Michael42