对需要加密查询的字段进行加密
1、sysdba用户执行
grant execute on dbms_crypto to xx;
grant execute on dbms_crypto to xx;
2、用户xx
create or replace function hash_md5(string_in in varchar2) return raw is
string_in_raw RAW(128) := UTL_RAW.CAST_TO_RAW(string_in);
encrypted_raw RAW(128);
begin
encrypted_raw := dbms_crypto.Hash(src => string_in_raw,
typ => DBMS_CRYPTO.HASH_MD5);
return encrypted_raw;
end;
/
create or replace function hash_md5(string_in in varchar2) return raw is
string_in_raw RAW(128) := UTL_RAW.CAST_TO_RAW(string_in);
encrypted_raw RAW(128);
begin
encrypted_raw := dbms_crypto.Hash(src => string_in_raw,
typ => DBMS_CRYPTO.HASH_MD5);
return encrypted_raw;
end;
/
3、调用过程hash_md5对字段进行加密
select hash_md5(x) from test;
参考:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28598517/viewspace-758354/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28598517/viewspace-758354/