Re: Spooling variable length output

From: Pauli Salmu <p.salmu_at_mn.medstroms.se>
Date: 1995/11/14
Message-ID: <488tgc$571_at_zorn.mnet.medstroms.se>#1/1


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.
> --
> Greg Hayes
> MD
> Hayford Systems Ltd
> +44 71 247 3005 Tel
> +44 71 247 3280 Fax

I'd guess you have to use some other tool than sqlplus or process the result file with a suitable batch editing program to trim it. Received on Tue Nov 14 1995 - 00:00:00 CET

Original text of this message