Re: spooling comma delimited file from sql where data does not wrap
From: Anurag Verma <anuragdba_at_gmail.com>
Date: Wed, 11 Jun 2008 10:25:42 -0700
Message-ID: <e2431aa40806111025hdaaabe0q9e7b9dc8be01b614@mail.gmail.com>
Date: Wed, 11 Jun 2008 10:25:42 -0700
Message-ID: <e2431aa40806111025hdaaabe0q9e7b9dc8be01b614@mail.gmail.com>
Hi,
Did you try "set wrap off"
I tested the below script and it is working...
set wrap off
set lines 5000
spool out1
select * from <TABLE_NAME>
where rownum < 2 ;
spool off
Thanks,
Anurag
On Wed, Jun 11, 2008 at 6:27 AM, Rick Ricky <ricks12345_at_gmail.com> 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.
>
-- Anurag Verma, Database Administrator ERCOT(Electric Reliability Council of Texas), Texas 76574 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 11 2008 - 12:25:42 CDT