Thanx Paul,
tried that but it isn't supported in the older version of Oracle that I'm
using.
<sigh> bit of a pain huh!
Paul Hennebry <paul_at_echofine.freeserve.co.uk> wrote in message
news:37D1D6A2.664ACB56_at_echofine.freeserve.co.uk...
> OK
> From memory
>
> in sqlplus :
> SET TRIMSPOOL ON
>
> This, I believe will get rid of trailing blanks in output spooled to a
file.
> Why this should differ from SET TRIMOUT ON for terminal output
> is beyond me.
>
> Andy Bates wrote:
>
> > Let's try again!
> >
> > I'm spooling the results of a query where the records can vary from
short
> > (say 40 chars) to long (say 800 chars)
> > I want the records in the file to be the same length as the query result
for
> > each row
> > rather than blank padded to linesiz.
> >
> > This is using Oracle 7.1 on VMS. I've got a sqlplus manual from a later
> > version which says that set trimspool on will do this, but it's not
> > recognised by 7.1, which only has set trim but this doesn't affect
spooled
> > output.
> >
> > I can remember doing what I want to do in the past, but I no longer work
at
> > the company which had the sqlplus manuals!
> >
> > The solution to this would be appreciated, I need to find the right set
of
> > command for the older version that I'm using.
> >
> > Thanks in anticipation
> > Andy.
>
Received on Sat Sep 04 1999 - 17:31:20 CDT
