Sending SQL query output to a txt file

To send output of a sql query to a text file use following commands,

spool c:emp.txt
/
select * from emp
/
spool off;

This will write all rows returned by query to emp.txt