spool file

i have about 75 fields with the total lenght of 2900 per record in a table. there are about 500 records.
How can i spool the values to a flat file

Thanks!

write a procedure using utl_file and create the flat file with the required format that you would want

Sam