select *from utms2.orders

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;

/

select *from utms2.sys_user

delete from utms2.sys_user;

update utms2.sys_user set passwd=md5(usercode||'Aa123456')

select MD5('SUNTENG1') from dual

select * from dual