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