direct result to file (without display)

[nour]

Hello,

I want to send the result of an sql query to a file without having the result (display)
in the screen. I don't remember if it is possible to do that with sql*plus ...

[pando]

store your sql in a text file then

#!/bin/ksh

sqlplus -s /nolog << EOF
set termout off
connect user/pass

spool text
@your_sql
spool off
EOF

[nour]

Thanks a lot