well it would be bit difficult to satisfy a requirement which requires something like this

#!/bin/sh

//iam reading the data for amounts from database

AMT[]=`sqlplus -s usrname/pswd <<EOD
set pagesize 0 feedback off verify off heading off echo on
select amount from tablename where condition;
EOD`

//writing to a file created at a specifed direcotry using a awk program

echo "$AMT[]" $noofrec | awk '
BEGIN
{
new=$1;
------------------------------------------------------------------
//i need to write the contents of the array in the file (which is created
at a specified location) in a loop that prints in each line contents of amount AMT[] array(as long as elements are there).

------------------------------------------------------------------
hence my problem is to print the elements in the array one by one in lines which are equivalent to no of elements in the array.

for i furthur read this file for processing

Iam able to get the contents into the array from db but couldnt print it in the file

please need suggestions asap.

Regards
Mahima
--------------------------------------------------------------------

printf "006%d" ,new; //this works fine with 2nd argumnet but dont know how
printf the arrays values?
}

{
printf "%d" ,AMT???
}'END