#Instead of using hard-coded login/password, merge them 
#into a single string and assign that to a variable
#Example --- login="tiger/scott"
#Additionally, merge all sql statements to be run in a string
#And write $sql_statement instead of writing each and every
#statement within echo quotes

echo "
set head off
select sysdate from dual;
exit
" | sqlplus -s tiger/scott




#user_name and password are user name and password for 
#the server host (no marks for guessing)

ftp -v -n host <<!
user user_name password
ascii
put file_name
bye
!