Generate MD5 Password

Pengen mudah generate MD5 password pada environment oracle? Demikian caranya.
Kita buat 2 function

Function 1
create or replace
function md5raw (text in varchar2)
return varchar2 is
hash_value varchar2(20);
begin
   hash_value := dbms_obfuscation_toolkit.md5 (input_string => text);
   return hash_value;
end;

Function 2
create or replace
function md5(text in varchar2)
return varchar2 is
hash_value varchar2(32);
begin
    select lower(rawtohex(md5raw(text)))
    into hash_value
    from dual;
    return hash_value;
end;


Ok, sekarang kita lakukan test
select md5('selamanyaindah') from dual

Hasilnya
36f1f16d203afc68acd890e6deb0efe4

reff..
http://bit.ly/1b6Kmt2