Re: triming whitespace from output of select * ...

In article <c2ec2c5b.0111260933.38d06202_at_posting.google.com>, throne7_at_my-deja.com says...
>
>I need to do some exporting of data. What i do is
>set colsep |
>spool fileout.txt
>select * from sometables where etc. etc.
>spool off
>
>Problems: there are too many white spaces between each of the fields
>in the output file. How do I get rid of these whitespaces. I would
>like to do this in the sqlplus select statement if possible.
>
>Forgive me if this is a faq. Havent' really got a chance to get a
>copy of the faq.

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

for one approach.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp