Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPLUS in AIX - linesize in output
SET TRIMSPOOL ON
This will trim the trailing whitespace of the line.
Pieter De Veuster wrote in message <928393329.691132_at_marvin>...
>Problem: when spooling to a file, the output linesize is always 80 (guess
>that's the default). I've tried altering this to e.g. 1000 but this merely
>gave me output in which every line has a length of 1000 chars. Is it
>possible to have an output linesize of exactly the right length (long
enough
>for all character output to fit but not longer/shorter). I've already
tried
>with rtrim but that doesn't help this problem either.
>
>Thanx,
>3.14ter
>
>
Received on Thu Jun 03 1999 - 23:49:46 CDT