-
Notifications
You must be signed in to change notification settings - Fork 3
oracle hash crypto
ghdrako edited this page Nov 29, 2023
·
1 revision
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"
Test