comparing data in two different tables

I have two tables (different schemas). One was loaded with our old extract process and the second with my new extract process. I want to verify that my new process produced identical results to the old process. I need to prove that all the columns and all the rows are the same.

I know I can offload the tables to Unix files and do a 'diff' but I prefer to do it in Oracle. Does anybody have a slick way of doing this?

Thanks. Rob Received on Wed Sep 15 1999 - 20:21:49 CDT