spooling comma delimited file from sql where data does not wrap
Date: Wed, 11 Jun 2008 09:27:06 -0400
I am running a query to dump some rows and I made the rows comma delimited like this
select col1||','||col2||','|| ....
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.Received on Wed Jun 11 2008 - 08:27:06 CDT