Please tell me how to get the sql output value from unix shell script.
My sample shell script is as given below.

A=00000
sqlplus -s system/manager @test.sql $A > aaa

My sample test.sql file is as given below.

select count(*) from tab_name where sol_id = '&1' ;
spool off
exit


Now I want to get the count(*) value from sql to unix shell script.

Try this:

Code:

A=$(sqlplus -s system/manager @test.sql $A)