HASH v18

The HASH function uses a user-specified algorithm to return the hash value of a RAW or CLOB value. The HASH function is available in three forms:

HASH
  (<src> IN RAW, <typ> IN INTEGER) RETURN RAW

HASH
  (<src> IN CLOB, <typ> IN INTEGER) RETURN RAW

Parameters

src

src specifies the value for which the hash value is generated. You can specify a RAW, BLOB, or CLOB value.

typ

typ specifies the HASH function type. EDB Postgres Advanced Server supports the HASH function types shown in the table.

Examples

This example uses DBMS_CRYPTO.HASH to find the md5 hash value of the string, cleartext source:

DECLARE
  typ INTEGER := DBMS_CRYPTO.HASH_MD5;
  hash_value RAW(100);
BEGIN

  hash_value := DBMS_CRYPTO.HASH('cleartext source', typ);

END;