sql query to know the Environment path in Linux in oracle Apps Technical

select variable_name, value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;

through sql Mask a Account Number(XXX5503) in bank account number in oracle apps 11i

select concat (substr(account_number,0,0),lpad(substr(account_number,-4), Length(account_number)-0,'X')) acc_num FROM hz_cust_accounts
                  WHERE cust_account_id = 3078 -- (cust_id)

sql query Reset password for Oracle Apps User in oracle apps 11i

DECLARE
   v_user_name      VARCHAR2 (30) := UPPER ('A1199024');
   v_new_password   VARCHAR2 (30) := 'welcome2airtel';
   v_status         BOOLEAN;
BEGIN
   v_status :=
      fnd_user_pkg.changepassword (username         => v_user_name,
                                   newpassword      => v_new_password
                                  );

   IF v_status = TRUE
   THEN
      DBMS_OUTPUT.put_line
                          (   'The password reset successfully for the User:'
                           || v_user_name
                          );
      COMMIT;
   ELSE
      DBMS_OUTPUT.put_line (   'Unable to reset password due to'
                            || SQLCODE
                            || ' '
                            || SUBSTR (SQLERRM, 1, 100)
                           );
      ROLLBACK;
   END IF;
END;