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>
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-lReceived on Wed Jun 11 2008 - 08:27:06 CDT