Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (x) AS
  SELECT 'aa' x FROM DUAL UNION ALL
  SELECT 'bb' x FROM DUAL UNION ALL
  SELECT 'cc' x FROM DUAL
3 rows affected

SELECT STANDARD_HASH(x, 'SHA1') AS hash,
       UTL_RAW.LENGTH(STANDARD_HASH(x, 'SHA1')) AS len,
       UTL_RAW.SUBSTR(STANDARD_HASH(x, 'SHA1'), 1, 8) AS byte8_hash,
       UTL_RAW.LENGTH(UTL_RAW.SUBSTR(STANDARD_HASH(x, 'SHA1'), 1, 8)) AS byte8_len
FROM   table_name


HASH
LEN
BYTE8_HASH
BYTE8_LEN


0xE0C9035898DD52FC65C41454CEC9C4D2611BFB37
20
0xE0C9035898DD52FC
8

0x9A900F538965A426994E1E90600920AFF0B4E8D2
20
0x9A900F538965A426
8

0xBDB480DE655AA6EC75CA058C849C4FAF3C0F75B1
20
0xBDB480DE655AA6EC
8

HASH	LEN	BYTE8_HASH	BYTE8_LEN
0xE0C9035898DD52FC65C41454CEC9C4D2611BFB37	20	0xE0C9035898DD52FC	8
0x9A900F538965A426994E1E90600920AFF0B4E8D2	20	0x9A900F538965A426	8
0xBDB480DE655AA6EC75CA058C849C4FAF3C0F75B1	20	0xBDB480DE655AA6EC	8