Export Data with Field Delimiters - SPOOL

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