Re: Fixed Line Sizes
Date: 1996/04/25
Message-ID: <N.042496.223944.78_at_ppp91.enterprise.net>#1/1
I have to do this quite often ORACLE support could offer no help. There are two solutions that I have had to work.
- The method you use ( Try a named pipe if you are worried about disk space )
- 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.
Received on Thu Apr 25 1996 - 00:00:00 CEST