Search notes:
Oracle SQL function: STANDARD_HASH
standard_hash(expr [, 'method'])
applies a hash function (
method
, default =
SHA1
) to
expr
and returns the result as a
raw
.
select
standard_hash(sysdate) sha1_implicit, -- raw(20 byte)
standard_hash(sysdate, 'SHA1' ) sha1_explicit, -- raw(20 byte)
standard_hash(sysdate, 'SHA256') sha256 , -- raw(32 byte)
standard_hash(sysdate, 'SHA384') sha384 , -- raw(48 byte)
standard_hash(sysdate, 'SHA512') sha512 , -- raw(64 byte)
standard_hash(sysdate, 'MD5' ) md5 , -- raw(16 byte)
from
dual;