Hey folks,
I need some guidance on loops with SQL (in Oracle more specifically).
In bash, this works:
Code:
while read a
do
echo $a
done < filename
So, trying to do something similar with SQL:
Code:
while read a
do
sqlplus user/password@"$a"
"show pdbs;"
done < filename
But it does not seem to work. No errors either.
For troubleshooting, I tried "echo" as follows and it looks correct.
So, trying to do something similar with SQL:
Code:
while read a
do
echo sqlplus user/password@"$a"
done < filename
And, above loop with echo shows sqlplus entry correctly, so am bit puzzled with this.
What am I missing?