dbms_crypto.hash : dbms_crypto « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_crypto
SQL>
SQL> declare
  2    l_in_val varchar2(2000) := 'CriticalData';
  3    l_hash   raw(2000);
  4  begin
  5    l_hash := dbms_crypto.hash (
  6       src => UTL_I18N.STRING_TO_RAW (l_in_val, 'AL32UTF8'),
  7       typ => dbms_crypto.hash_sh1
  8    );
  9    dbms_output.put_line('Hash='||l_hash);
 10  end;
 11  /



SQL>
SQL>








31.5.dbms_crypto
31.5.1.dbms_crypto.randombytes
31.5.2.dbms_crypto.hash
31.5.3.dbms_crypto.hash_sh1
31.5.4.dbms_crypto.mac
31.5.5.utl_i18n.string_to_raw and dbms_crypto.encrypt
31.5.6.DBMS_CRYPTO.encrypt_aes128 + DBMS_CRYPTO.chain_cbc + DBMS_CRYPTO.pad_pkcs5
31.5.7.dbms_crypto.ENCRYPT_AES128