Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Verifying data across 2 db
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?
Received on Thu Apr 10 2003 - 04:17:07 CDT