Shell Programming and Scripting

Hi readers,
I have two shell scripts running on linux machine.
Both the scripts do the following task
- Connect to DB
- Create temp files
- run select statement on table
- write the rows returned on temp file

Sample code is below

Code:

#!/bin/sh
export ORACLE_HOME=/content/oracle/10.2.0
echo "columns" >  /home/user/filename_$(date +%m%d%Y).txt;
/home/oracle/10.2.0/bin/sqlplus -s dbuser@schema/password << EOF > /home/user/filename_$(date +%m%d%Y).txt
SET LINESIZE 1000
SET PAGESIZE 1000
SET HEADING OFF
SET ECHO OFF
SET FEEDBACK OFF
select  statement with where clause;
exit;
EOF

Both the shell scripts do the same process but create separate temp files based on where clause. two files have difference of only where clause.

How can I combine the process and generate temp files using 1 shell script.
I tried replicating the code and inserting in 1 shell file but only 1 temp file was generated with "where clause 1".

Please advice.

Thanks
Manu

This is much easier with a SQL "spool" command.
The logfile names can be Shell variables if required.

Code:

spool first_logfile_name
select  statement with where clause;
spool off
spool second_logfile_name
select  statement with where clause;
spool off