Shell Programming and Scripting

for j in `cat $INPUT_FILE | grep Account`
do
  echo $j  
  account_no=`echo $j|cut -d'"' -s -f2`
  echo $account_no
  row_out=`sqlplus -S $LOGIN << BEOF |grep -v '^$'|grep -v selected
  set heading off  
  set pages 0
  SELECT address
  FROM  account_table
  WHERE account_no = '$account_no'
BEOF
`
    echo $row_out >> $INPUT_FILE.out
done

row_out=`sqlplus -S $LOGIN << BEOF |grep -v '^$'|grep -v selected 
  set heading off  
  set pages 0
  SELECT address
  FROM  account_table
  WHERE account_no IN ( $account_no )
BEOF
`

sqlplus -S $LOGIN << BEOF |grep -v '^$'|grep -v selected > ${INPUT_FILE}.out
  set heading off  
  set pages 0
  SELECT address
  FROM  account_table
  WHERE account_no IN ($account_no)
BEOF

Account "ACC_1"
Account "ACC_2"
Account "ACC_3"

SELECT address
FROM  account_table
WHERE account_no IN (
'ACC_1',
'ACC_2',
'ACC_3'
);