Shell script : Redirect sql query output to a file

Inside a shell script, I have written below sqlq(){ result=`sqlplus -S sss/eee@sid q.sql sqlq q.sql --------------- I need to direct the output to a file. I have tried spool inside q.sql like below but didn't work echo "SPOOL /tmp/test.txt; select * from emp';SPOOL off" > q.sql