Re: SQL*Plus question: set linesize nnnnn?

In Article<4louqf$hjt_at_phobos.Candle.Com>, <al_dev_at_candle.com> write: -Posting-Host: aldev.candle.com
>
> How do I avoid unwanted spaces after the fields as in the case below -
>
> File j.sql is as follows:
> set tab off;
> set linesize 1000;
> select table_name from dict where table_name='V$LOCK';
> quit;
>
> unixprompt> sqlplus sys/password _at_j.sql > j.out
>
> in j.out I find extra spaces upto line size 1000 chars. I need to use tab
 off to avoid tabs
> and set trimout on does not work as per User guide......

Here's what I do:

spool ../log/PAT_1.logX
.. etc.
spool off;
!sed -e 's/[\ ]*$//' -e '/^$/d' <../log/PA_T_1.logX >../log/PA_T_1.log && rm../log/PA_T_1.logX

This removes all trailing blanks using the unix sed command and writes out a new file.  

\louis Received on Mon Apr 29 1996 - 00:00:00 CEST