sql对字符串进行md5加密/生成随机32位id

oracle

--先创建一个md5加密函数
CREATE OR REPLACE FUNCTION MD5(passwd IN VARCHAR2)RETURN VARCHAR2
    IS
        retval varchar2(32);
    BEGIN
        retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => passwd));
    RETURN retval;
    END;
--MD5加密32位小写
select lower(MD5('123456')) from dual;
--MD5加密32位大写
select upper(MD5('123456')) from dual;

--32位小写随机id
select lower(rawtohex(sys_guid())) from dual;

sqlserver

--MD5加密小写32位
select LOWER(substring(sys.fn_sqlvarbasetostr(HashBytes('MD5','123456')),3,32));
--MD5加密大写32位
select UPPER(substring(sys.fn_sqlvarbasetostr(HashBytes('MD5','123456')),3,32));

--32位小写随机id
select lower(replace(newId(), '-', ''));