Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Need simple HASH-algorithms for Oracle-Database
Chris_R42
Member Posts: 1 Green Ribbon
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.