Forum Stats

  • 3,853,567 Users
  • 2,264,240 Discussions


Need simple HASH-algorithms for Oracle-Database

We want to compare data that is stored in an Oracle-database with data we have in an IBM DB2-Database.

There are two possible methods: line by line (field by field) or column by column.

We are able to aggregate numbers and dates using SUM. But with strings (VARCHAR2) it is more difficult. In DB2 I found the function HASH4 that calculates an integer using ADLER32 or CRC32.

I am able to write ADLER32 with PL/SQL but it is too slow. Having this function given by Oracle it would be easier for me. And I am sure that others will have advantages from this.