Getting the output of a sql query into a file

Hi,

I want to fire an sql.I want the output tobe written into a file.How to catch the output after executing an SQL?Some code will help...

Thanks in advance