Message-Id: <10602.115649@fatcity.com> From: Steven Monaghan Date: Mon, 28 Aug 2000 12:17:50 -0400 Subject: Verify data is identical methods - which is best? There is a major batch process running here, and I want to make sure that the modifications I have made to the SQL and PL/SQL create an identical result. I have an old copy of the result in temp tables, and the new data as well. Here were the ideas I had: 1 - Do a join on all columns and make sure num rows returned = num rows in each table. 2 - PL/SQL cursor on one table and check result on other table based on PK 3 - dump data to text files and diff in UNIX. Any suggestions on which would be best / fastest and if one of those methods above doesn't really give me the results I am looking for? TIA, Steve Monaghan ------------------------------------- Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY MonaghaS@mscdirect.com -------------------------------------