Re: spooling comma delimited file from sql where data does not wrap
- From: "Jack van Zanen" <jack@xxxxxxxxxxxx>
- To: ricks12345@xxxxxxxxx
- Date: Thu, 12 Jun 2008 08:49:24 +1000
I think you have your answer already
Just a little tip:
set colsep "," -- saves you from having to put the ||','|| between each
column
Jack
On 11/06/2008, Rick Ricky <ricks12345@xxxxxxxxx> wrote:
>
> 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.
>
--
J.A. van Zanen
Other related posts:
