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;

Note

The second parameter must be in uppercase, otherwise an ORA-00904: invalid identifier error is thrown.
This function is not available in PL/SQL.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759414056, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/functions/standard_hash(52): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle SQL function: STANDARD_HASH

See also