Oracle Database MD5 algorithm

Because of the problem of our initial data, we need batch import, we have created Oracle's MD5 algorithm to encrypt the username and password;
Simple two-step operation:

1. Write function:
Create or Replace function "MD52" (passwd in VARCHAR2) return VARCHAR2 is
retval Varchar2 (32);
Begin
retval: = Utl_raw.cast_to_raw (dbms_obfuscation_toolkit.md5 (input_string = passwd));
return lower (retval);
End

2, update the data call;
Update usertable SET "PASSWORD" = MD52 ("CONCAT" (userid, "CONCAT" (userid, ' [email protected] #321 '))) where password= ' q3qtuxgsi7b5u60nfmu+qa== ';

UserID and password are encrypted at the same time

Done!

Oracle Database MD5 algorithm