Export Data with Field Delimiters

SQL> SET HEADING OFF;
SQL> SET FEEDBACK OFF;
SQL> SET LINESIZE 1000;
SQL> SPOOL oraclexe	estfyi_links.txt;
SQL> SELECT id ||','|| url ||','|| notes ||','|| counts
  ||','|| created FROM fyi_links;
......
SQL> SPOOL OFF;