MD5 Hash Function for Oracle

Basically there are 2 functions needed. Some people prefer the raw hash instead of the hex equivalent.
1. md5raw - for encoding text in raw md5 hash
2. md5 - for converting raw md5 hash to hex.

Here’s the code for the md5raw function.

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;

and the code for the md5 function.

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;

Now you can do something like this.

select md5('koala') from dual;
 
|---------------------------------------|
|MD5('koala')                           |
|---------------------------------------|
|a564de63c2d0da68cf47586ee05984d7       |
|---------------------------------------|

Access VirtualBox Shared Folder in Ubuntu Guest

I have been doing this for quite some time now but I failed to document it. First, install the VirtualBox Guest Additions on your host. Then you create a mount point (assuming it is /media/shared).

$ sudo mkdir /media/shared

You may change the path if you want. Mount the shared folder using the command below.

$ sudo mount -t vboxsf <folder> /media/shared

Replace the <folder> above with the correct shared folder name. Enjoy.

Welcome 2011!

Happy New Year! Prospero Ano Nuevo!