Function Decrypt and Encrypt

This function is useful for encrypt  the secret data,an example thif function can be used to encrypt the “sensitive” filed in the table :

CREATE OR REPLACE function f_decrypt( p_str in raw ) return
varchar2
as
begin
return utl_raw.cast_to_varchar2(
dbms_obfuscation_toolkit.DESdecrypt
( input => p_str,
key   => utl_raw.cast_to_raw(‘MagicKey’) ) );
end;
/

CREATE OR REPLACE function F_Encrypt( p_str in varchar2 )
return raw
as
l_data  varchar2(255);
begin
l_data := rpad( p_str, (trunc(length(p_str)/8)+1)*8, chr(0) );
return dbms_obfuscation_toolkit.DESEncrypt
( input => utl_raw.cast_to_raw(l_data),
key => utl_raw.cast_to_raw(‘MagicKey’) );
end;
/