Zafar

To set the buffer size.. set serveroutput on size 1000000 To change the password of oracle apps user.. DECLARE v_success BOOLEAN; BEGIN v_success := apps.fnd_user_pkg.changepassword('OPERATIONS','welcome123'); COMMIT; END; BEGIN if apps.fnd_user_pkg.changepassword('OPERATIONS','welcome321') then  dbms_output.put_line('Password changed'); else  dbms_output.put_line('Unable to change password '); end if; COMMIT; END; To create a tar file, give the following command: tar -cvf filename.tar directory-to-tar/* To see what files are in a tar archive, give the following command: If the file is a .tar.Z, then you use the uncompress command instead of the gzip command as follows: uncompress filename.tar.Z tar -xvf filename.tar tar -tvf filename Explanation of options: -c tells it to create -z tells it to compress -x tells it to expand -t is for table of contents -v gives you verbose output (instead of no o...