CODEWITHSUNDEEP
oracle-databasehashsnowflake-cloud-data-platform
Ankit Srivastava
Ankit Srivastava

Reputation: 195

ORA_HASH alternative in Snowflake

I am trying to find the alternative to Ora_hash in Snowflake. My intent is to find an alternate in SNowflake which generates same HASH value for a string which ORA_HASH generates.

I tried using HASH, MD5, SHA1, SHA2 in Snowflake but none of them generates the same value as ORA_HASH.

Is there any other function which might match ORA_HASH or is there any other way?

Upvotes: 2

Views: 905

Answers (1)

Joe King
Joe King

Reputation: 3011

Oracle's ORA_HASH is a relatively light hashing algorithm. However it is proprietary, so the details of the implementation are not published, as far as I know. However, being relatively lightweight, it might be possible to reverse-engineer it, and write your own. See the following answer for some pointers if you want to do that:

What is the algorithm used by the ORA_HASH function?

Upvotes: 0

Related Questions