Re: Strange behavior with SQLPLUS (Oracle)

easy - if u know it:

  set trimspool OFF
this will trim all spaces !

cheers

     Roelof Schierbeek

Roger Redford <dba_222_at_yahoo.com> schreef in .
> I really noticed this symptom when I did spool. I set the linesize
> to 32000. For a few thousand short rows, I had 70 megs of output.
> Most of the output was blanks. When using more, pages and pages of
> blanks for each line of output.
>
> Any ideas how to fix it?
>
Received on Wed Jan 15 2003 - 13:02:13 CST