oracle 加密怎么解密,oracle加密和解密

1、加密

create or replace function close_password(passwordStr in varchar2) return varchar2 is

/**

功能：对密码进行加密 返回值：为加密后的值

作者：王聘群

日期：2012-06-04

**/

begin

declare v_password varchar2(100);

begin

select translate(passwordStr,'qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890!@#$%^&*'

,'M!qNw@eBr#tVy$uCi%oXp^aZs&dLf*mWn1Qb2AvE3ScRxD4FzTlG5YkH6jUhJ7gI8KOP90') into v_password from dual;

return v_password;

end;

end close_password;

2、解密

create or replace function open_password(passwordStr in varchar2) return varchar2 is

/**

功能：对加密后密码进行解密 返回值：为解密后的值

作者：王聘群

日期：2012-06-04

**/

begin

declare v_password varchar2(100);

begin

select translate(passwordStr,'M!qNw@eBr#tVy$uCi%oXp^aZs&dLf*mWn1Qb2AvE3ScRxD4FzTlG5YkH6jUhJ7gI8KOP90'

,'qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890!@#$%^&*') into v_password from dual;

return v_password;

end;

end open_password;