Re: spooling comma delimited file from sql where data does not wrap
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: ricks12345@xxxxxxxxx
- Date: Wed, 11 Jun 2008 20:12:16 -0700
http://asktom.oracle.com/tkyte/flat/
not via sqlplus, but exactly what you probably want
On Wed, Jun 11, 2008 at 6:27 AM, 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.
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
