安全等保加密存储(oracle)

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 LOWER(retval);--大小写转换

END;

declare
   cursor c_user is   --游标
   SELECT u.u_name,u.U_PASSWORD from USERS u;   
   top_ten number:=0;
begin  
   for r_user in c_user loop --循环 
				--更新USERS的表
				dbms_output.put_line(r_user.u_name);
				update USERS set U_PASSWORD = 
				(select md5(r_user.U_PASSWORD) from dual) 
				where U_NAME = r_user.u_name;
   end loop;  
end; 

update Users gu 
   set gu.u_password = 
       (select md5(gu.u_password) from dual);