Re: sqlplus infinite length lines

It works fine, but I assume there is a better way to do it. What if I had a field with a very large variable length and I wanted to make sure I always saw all the data. Is there a way to tell SQLPLUS never to wrap the spooled data?

TIA, Jim

In article <wB705.6$p62.1117_at_wdc-read-01.qwest.net>,   "Mike Dwyer" <dwyermj_at_co.larImer.co.us> wrote:
> I'm not clear about your statement. Do the two statements prevent
 wrapping?
> That is what they are intended to do; that is the correct method.
>
> Or, do you still get wrapping even after issuing the two commands? If
 so,
> please provide additional information about where you see the wrapped
 lines.
> (In SQL*Plus, or when you display the spool file, or elsewhere.)
>
> <jimbob4334_at_my-deja.com> wrote in message
> news:8hqqva$s8l$1_at_nnrp1.deja.com...
> > How do I keep the lines from wrapping when spooling to a file? I am
> > currently using
> > set linesize large_number
> > trims on
> >
> >
> > There probably is a better way.
> >
> > --
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--



Sent via Deja.com http://www.deja.com/
Before you buy.