*** EXPORTING DATA
Here is how to export data to a space delimited text file
SET LINESIZE 500 FEEDBACK OFF TRIMSPOOL ON TERMOUT OFF HEAD OFF PAGESIZE 0 term off SPOOL /directory/name/outputfile.dat SELECT * from table; SPOOL OFF