Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Verifying data across 2 db
PoohPooh wrote:
> I am doing a verification of the same set of data loaded to an Ingres
> DB and an Oracle DB. I wanted to do some kind of "checksum'. For
> numeric attributes (integer, float ...), it's easy. I can just do a
> summation of the numeric columns and compare the total across the 2
> db. However, I have trouble with checking string attributes (char,
> varchar ...). Summation won't work on string attributes. Is there any
> good suggestion?
The book "Perl for Oracle DBA's" shows how to do this. Received on Thu Apr 10 2003 - 19:45:52 CDT