I have a batch file that starts up the oracle, executes a query and spools the result to a text file and exits. The code goes like this...
sqlplus ccn/yak25 @C:\temp\script.sql
notepad.exe C:\temp\output.txt

and script.sql has the code:
spool C:\temp\output.txt
select * from emp;
spool off
exit

I want to do the same job on Unix, do I write a shell script like this
#!/bin/sh

sqlplus 'username/password@instance' '@dir/query.sql>dir/output.txt
exit
OR
nave the same spool stteaments in the query.sql file and delete dir/output.txt from the script?

Please help

sqlplus 'username/password@instance'<<!
@dir/query.sql>dir/output.txt
exit
!