create function mazeeddecrypt(key in varchar2, value in varchar2)
return varchar2 as
language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
SELECT fnd_user.user_name, fnd_user.LAST_UPDATE_DATE,
fnd_user.description,mazeeddecrypt('APPS' , fnd_user.encrypted_user_password) decrypted_user_password
FROM fnd_user where USER_NAME like UPPER('%TEST%')
return varchar2 as
language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
SELECT fnd_user.user_name, fnd_user.LAST_UPDATE_DATE,
fnd_user.description,mazeeddecrypt('APPS' , fnd_user.encrypted_user_password) decrypted_user_password
FROM fnd_user where USER_NAME like UPPER('%TEST%')
No comments:
Post a Comment