I am new to Unix and  am trying to store output of one sql query in a unix array.

#bin/bash
myarray=`sqlplus -s username/password@sid <<eof
set heading off;
set feedback off;
set pagesize 0;
set echo off;
set linesize 1000;
select department from  Customer;
eof`

for ((i=0; i<${#myarray[@]}; i++))
do
echo ${myarray[$i]}
done
exit;`