SQLPUS spool out format

[hannah00]

Hi all,

I have tables with 40 columns, and I need to be able to query the data from this table with the below condition:

1. data can't break to the second line so I have as follow:

SQL> set linesize 1000
SQL> set wrap off
SQL> set heading off
SQL> spool foo.cvs


2. how can I be sure data of each column goes into its own columns so I can reload this data

[stecal]

http://asktom.oracle.com/~tkyte/flat/index.html