my_host>>cat aaa.sh
#!/bin/sh
sqlplus -s usr/pass@db <<EOF > /tmp/tmp.txt
set pagesize 0 feedback off verify off heading off echo off
select 'some space'||','||owner||','||count(*) from all_objects group by owner;
EOF

echo "method1"
#change field separator used by "read" to comma
IFS=,
while read x y z the_rest
do
  echo "x=$x y=$y z=$z"
done < /tmp/tmp.txt

echo "method2"
awk -F, '{print "x="$1, "y="$2, "z="$3}' /tmp/tmp.txt

my_host>>aaa.sh
method1
x=some space y=PUBLIC z=2455
x=some space y=SYSTEM z=13
x=some space y=SYS z=3530
x=some space y=WMSYS z=104
x=some space y=OUTLN z=3
method2
x=some space y=PUBLIC z=2455
x=some space y=SYSTEM z=13
x=some space y=SYS z=3530
x=some space y=WMSYS z=104
x=some space y=OUTLN z=3