Table contents to flat file

[bang_dba]

There are few ways to accomplish your requirement:

through SQL statment

Select col1 || ',' || col2
from <>

secondly

through PL/SQL procedure using UTL_FILE package

Through PL/SQL u can have better control on formating

In first method u specified, does the output need to be spooled ??