Just posting additional info concerning Chris' method. This is what the Oracle documentation says about "Creating a flat file". Pay attention to the SET COLSEP instruction, which allows you to define a separator.
Creating a Flat File
When moving data between different software products, it is sometimes necessary to use a "flat" file (an operating system file with no escape characters, headings, or extra characters embedded). For example, if you do not have Oracle Net, you need to create a flat file for use with SQL*Loader when moving data from Oracle8 to Oracle9i.
To create a flat file with SQL*Plus, you first must enter the following SET commands:
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF SPOOL OFF
After entering these commands, you use the SPOOL command as shown in the previous section to create the flat file.
The SET COLSEP command may be useful to delineate the columns. For more information, see the SET command.
Sending Results to a File
To store the results of a query in a file--and still display them on the screen--enter the SPOOL command in the following form:
SQL*Plus stores all information displayed on the screen after you enter the SPOOL command in the file you specify.
<<<END ORACLE DOCUMENTATION>>>