Oracle spool output to file

Use following commands to spool oracle script

SQL> Spool on
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off

If you want to off the header use following commands

SQL> Spool on
SQL> set heading off <===
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off