Re: Spooling variable length output

In article <487pjm$n4m_at_ixnews3.ix.netcom.com> chuckh_at_ix.netcom.com (Chuck Hamilton) writes:

> Greg Hayes <greg_at_hayford.demon.co.uk> wrote:
>
> >If I want to spool the output from a select statment to a file
> >then I SET LINESIZE 338 let us say. However if the data in the
> >file is comma delimited (as in "abcd","defg","","1","sfgdtg"),
> >thenthe record is always 338 bytes long instead of 29 as in
> >the example above. Does anyone have a soution to this.
> >--
>
> If you find a way that doesn't involve the operating system, let me
> know.

SQL*Plus 3.2 (with Oracle7 release 7.2) has a SET TRIMSPOOL option that strips trailing whitespace from spooled lines.

Chris

-- 
Christopher Jones, cjones_at_au.oracle.com