Executing Multiple Queries in parallel in Shell

Shell Programming and Scripting
1

I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit.

Sample Query:

SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2

SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2

Result of the above queries need to assign in variables and shell needs to exit once execution of all queries completed.

Can any one post how it can be achieve in shell script?

Envionment: LINUX
Database : ORACLE 11.G

2

two times you have to connect. or else create two shells containing the sqls and call using nohup command and check the exit status.

#!/bin/ksh

x=`sqlplus scott/tiger -s / <<endl | grep KEEP | sed 's/KEEP//;s/[   ]//g'
Select Count(*) from TABLE GROUP BY COL1,COL2;
exit
endl`
y=`sqlplus / <<endl | grep KEEP | sed 's/KEEP//;s/[   ]//g'
Select Count(*) from TABLE GROUP BY COL1,COL2;
exit
endl`
3

Also all the queries are writted in Parameter file. I need to read the queries from parameter one by one and pass to the Oracle.