Verify data is identical methods - which is best?

From: Steven Monaghan <MonaghaS_at_mscdirect.com>
Date: Mon, 28 Aug 2000 12:17:50 -0400
Message-Id: <10602.115649@fatcity.com>

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_at_mscdirect.com

---

Received on Mon Aug 28 2000 - 11:17:50 CDT