Hello,
Could someone tell me why this still returns headings?
echo "SELECT columnA from tableA group by columnA;" |
sqlplus -s ${DB_CONNECT}
set heading OFF |
while read line
do
arr[$i]="$line"
echo ${arr[${i}]}
let i=$i+1
done
Hello,
Could someone tell me why this still returns headings?
echo "SELECT columnA from tableA group by columnA;" |
sqlplus -s ${DB_CONNECT}
set heading OFF |
while read line
do
arr[$i]="$line"
echo ${arr[${i}]}
let i=$i+1
done
echo "set head off;
SELECT columnA from tableA group by columnA;" | sqlplus -s ${DB_CONNECT}
Thanks this worked!