Re: Fixed Line Sizes
Date: 1996/05/01
Message-ID: <4m7qdq$sop_at_ins3.coned.com>#1/1
Set trimspool on is the answer. Works on 7.2.3.
kengaul_at_enterprise.net wrote:
>I have to do this quite often ORACLE support could offer no help. There are two
>solutions that I have had to work.
>1. The method you use ( Try a named pipe if you are worried about disk space )
>2. A silent SQLPLUS session with set tabs, headings etc off...
>eg sqlplus -s usr/pass script.sql
>script.sql
>----------
>set tabs of
>set headings off
>set page 0
>set space 0 and all the other stuff to stop it outing anything except data.
>I think there was a problem if your max record length was over a certain amount
>but I can't remember.
>I have to say I stuck with sed.
>Ken Gaul ---
>> I am writing sqlplus queries on a regular basis that need to have variable
>> line lengths (i.e. no padding with spaces to a fixed length). Is there a way
>> to force sqlplus to not add the spaces at the end of the line? I have tried
>> every possible "set" command available with no success. I finally resorted
>> to
>> running a "sed" on the output from the query to strip off the trailing
>> spaces.
>> Any response to this matter would be greatly appreciated.
Utrankas_at_coned.com (Sameer Utrankar) Received on Wed May 01 1996 - 00:00:00 CEST