Shell Programming and Scripting

#! /bin/bash

tname="table"

for i in *
do
sqlstr="create table $tname$i as select account_no, balance from records_all"
sqlplus username/password@db_name<<EOF
  execute immediate $sqlstr;
EOF

+ tname=table
try.ksh[7]: syntax error at line 10 : `<<' unmatched

tname=table
try.sh: syntax error at line 15: `end of file' unexpected

#! /bin/ksh
tname="table"
for i in temp*
do
    OUTPUT=$(sqlplus -silent username/password@db_name << OK
    set pages 0 feedback off
    create table $tname$i as select account_no, balance from records_all;
OK)
echo " $tname$i table creation is successful "
done