spooling comma delimited file from sql where data does not wrap

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 11 Jun 2008 09:27:06 -0400
Message-ID: <81f4c0700806110627s2e63d2bfya7073e807321d5e0@mail.gmail.com>


I am running a query to dump some rows and I made the rows comma delimited like this
select col1||','||col2||','|| ....
from table

I set lines 5000.

I want to spool it so the spool file does not wrap. This way I can load the data into excel. The data keeps wrapping and when i import it, I get it wrapped in excel. its alot of columns. lines 5000 should be sufficient. I just don't have enough screen space for it all.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 11 2008 - 08:27:06 CDT

Original text of this message