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       |
|---------------------------------------|

Comments

Architecture Complexity

Here are the items to consider: Coding to an interface Service Oriented Architecture Automated Testing Domain Driven Design Custom Data Access Layer Layered architecture Complexity is relatively equal the number of lines of code. Note that complexity is not bad. It must be justified.

Android Studio:Unknown Host Error

After installing Android Studio, I got the following error: Unknown host 'services.gradle.org'. Please ensure the host name is correct. If you are behind an HTTP proxy, please configure the proxy settings either in Android Studio or Gradle. Consult IDE log for more details (Help | Show Log) Solution File --> Settings --> HTTP Proxy --> Auto-detect proxy settings

Java Lambda Expressions / Closures

Lambda expressions are just (anonymous) functions. f(x) = x can be expressed as x→x f(x, y) = x*x + y*y can be expressed as x, y→x*x + y*y In simple Java terms, 1. Return an int 23 with a void argument int j = { => 23 }.invoke(); 2. Closure with 1 argument, convert 23 kilograms to pounds double j = { double kilograms => kilograms*2.2D }.invoke(23); 3. Closure with 2 arguments, get the sum of the 2 squares int squareSum = { int x, int y => (x*x) + (y*y) }.invoke(2,3); 4. Closure returning an instance and invoking an instance method { new RocketLauncher() }.invoke().fire(); Every time a closure is created at compile time, an interface is automatically created for each expression having an invoke method with a signature depending on the number of arguments, then an anonymous subclass of this interface is constructed. Enjoy!

Coding Blog

Search This Blog