Shell Programming and Scripting

table_name table_name1
U1 T1
U2 T2

#usr/bin/kah
t='sqplus-s test/test<<EOF
set pagesize 0 feedback off verify off heading off echo off;
select table_name from table;
exit;
EOF'
echo $table_name

l='sqlplus test/test<<EOF
set pagesize 0 feedback off verify off heading off echo off;
select table_name1 from table;
exit;
EOF'

echo $table $table_namel

cd home/bin
run $table.sql $table $table_name1

#! /usr/bin/zsh

query="set pagesize 0 feedback off verify off heading off echo off;
select table_name, table_name1 from table;"

while read line
do
    table_name=$(echo $line | awk '{print $1}')
    table_name1=$(echo $line | awk '{print $2}')
    echo $table_name, $table_name1
done <<< $(echo $query | sqlplus -S test/test)

#!/bin/ksh
# Whatever else you need first
:
:
:
sqlplus -s <<EOF > /path/to/some/file       # Capture all the output into a file
   test/test
   set pagesize 0 feedback off verify off heading off echo off;
   select table_name, table_name1 from table;
   exit;
EOF

while read table table_name1
do
   echo "My \$table is \"$table\""
   echo "My \$table_name1 is \"$table_name1\""
done < /path/to/some/file