Re: Remove white space in spool data file

From: kw <none_at_nowhere.where>
Date: Wed, 27 Feb 2002 16:44:04 +0100
Message-ID: <3C7CFEC4.7C049B74@nowhere.where>

set trimspool on
set trimout on
column XXX format a30 (30 chars)

Simon wrote:

> I would like to remove the white space in a spool file.
>
> I am able to do this by doing the RTRIM(LTRIM(COLx)), but is there an
> easy way to do this by using a SET command instead of wrapping the
> rtrim & ltrim around each an every column?
>
> Change from the current: XXXXX | 111| 0|01/29/2002|ABCD
> To: XXXXX|111|0|01/29/2002|ABCD
>
> TIA
>
> I am using Oracle 8.1.7
>
> Simon
Received on Wed Feb 27 2002 - 09:44:04 CST