oracle hash crypto - ghdrako/doc_snipets GitHub Wiki

sha256

CAST(TRIM(UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(DBMS_CRYPTO.HASH(UTL_RAW.CAST_TO_RAW(nvl(trim(ZK_NR_KARTY),' ')),4)))) AS VARCHAR2(44)) AS "ZK_NR_KARTY"

sha1

CAST(TRIM(UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(DBMS_CRYPTO.HASH(UTL_RAW.CAST_TO_RAW(nvl(trim(ZKH_NR_KARTY),' ')),3)))) AS VARCHAR2(28))AS "ZKH_NR_KARTY"