Shell Programming and Scripting

Wait. Are you thinking this code reads the output from sqlplus and sends each line into an array called AMT? It doesn't. You need something like this (at least in BASH):

Code:

AMT=(`sqlplus -s usrname/pswd <<EOD >$TMPDIR/$0.$$ 
set pagesize 0 feedback off verify off heading off echo on
select amount from tablename where condition;
EOD`)

# now you have contents in an array named A.

# print it as a list
echo ${A[@]} | tr ' ' '\n'

# do stuff with each line
for value in ${A[@]}
  echo $value
done

Use xargs if you have lines of input and want to do something so that all the lines appear on one output line.

working with Ksh this works only in BASH.

I cannot help you. You are either lying or playing a game. In your first post in this thread, you used code that was to run "#!/bin/sh", which either means the real bourne shell or, in some systems, bash, and definitely not ksh. You simultaneously want to have output from a command put in a shell array and fed into awk. Finally, you make no apparent effort to help yourself.

Thank You so much!

Regards
Shaik

Thank you
Regards,