Shell Programming and Scripting

Hi, I am very new to UNIX environment. And I am stuck in this problem.

In my Unix server, I have a file called "tablelist.txt" which gives me a list of the tables in my oracle database like shown below.

bmp.table1
bmp.table2
bmp.table3
:
:
bmp.table20

All these tables have 'batch_id' column.

Now i need a Unix script which will loop through each line of tablelist file. and extract the data from each table for that batch_id and load into separate files.

At the end of the process, i should have 300 files which has records of 300 tables.

Note: I am using SQLPLUS In Unix server.

Try this:

Code:

#!/bin/ksh
seq=1
while read table_name
do
  SqlOut=`sqlplus -s username/password@instance << EOF
  set echo off head off feed off pagesize 0 trimspool on linesize 1000
  spool batch_id_${seq}.txt
  select batch_id from ${table_name};
  spool off;
  exit;
  EOF`
  seq=$(( seq + 1 ))
done < tablelist.txt