#$1 user; $2 password; $3 servicename; $4 spool out file; $5 spool select sql scripts file
sqlplus -s $1/$2@$3 << EOF
set linesize 120
set pagesize 2000
set newpage 1
-- not display exec time
set echo off
set timing off
-- not display table head information
set heading off
-- not display select data in screen
set termout off
-- trim space when spooling data to file
set trimspool on
-- not display select data rows
set feedback off
spool $4
@$5
spool off
EOF