create or replace function open_password(passwordStr in varchar2) return varchar2 is
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;
create or replace function close_password(passwordStr in varchar2) return varchar2 is
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;