Output the Data from a select to a file

[gurupot]

Hi,

I want to write a script which executes a select statement and outputs the data to file in the format I specify. What would be the easiest way to accomplish this.

Thanks.