Shell Programming and Scripting

 
 
result=`sqlplus -s / <<EOF
set pages 0 feed off;
set feedback off;
spool abc.txt
select rcrd_cnt||','||to_char(data_acq_cyc_ts,'dd.mm.yyyy') from rptg.r_sb_stg_data_fl_acq_cyc_cntl where srce_id = 1 and data_acq_cyc_cntl_id =$cntl_id and 
srce_fl_id = $p ;
spool off;
exit; 
EOF;

$ result=val1,val2
$ OLDIFS=$IFS
$ IFS=","
$ set -- $result 
$ echo $1
val1
$ echo $2
val2
$ IFS=$OLDIFS
$

$ result=val1,val2
$ v1=${result%%,*}
$ v2=${result##$v1,}
$ echo $v1
val1
$ echo $v2
val2
$