AIX

set -A DATE_RANGE `sqlplus -s **/**@** << EOF
set termout off
set echo off
set serveroutput off
set pagesize 0
set linesize 500
set heading off
set verify off
set feedback off
select (to_char(MAX_LOAD_TRAN_DT,'YYYY-MM-DD HH:MM:SS')||','||BACK_UPDT_DAY_CNT) as DATE_RANGE from
TABLE A,TABLE B
WHERE TRGT_TBL_NM IN ('**')
AND A.SRC_TBL_INFO_KEY=B.SRC_TBL_INFO_KEY;
quit;
EOF`
 
The output of the query is -
 
2013-09-21 12:09:00,5 
2013-09-19 22:36:00,7
2013-09-20 06:28:00,1 
 
So, the output I wanted to see in the array variables is-
 
${DATE_RANGE[0]} - 2013-09-21 12:09:00,5 
${DATE_RANGE[1]} - 2013-09-19 22:36:00,7 
${DATE_RANGE[2]} - 2013-09-20 06:28:00,1
 
But the output am getting is-
 
 
${DATE_RANGE[0]} - 2013-09-21 
${DATE_RANGE[1]} - 12:09:00,5 
${DATE_RANGE[2]} - 2013-09-19 
${DATE_RANGE[3]} -  22:36:00,7

OLDIFS="$IFS"
IFS="
"

# code that populates the array

IFS="$OLDIFS" # Restore it, since lots of things depend on default behavior here

# You can now use your array as expected