Re: sqlplus clean output?

In article <382B3BFF.6A55D564_at_us.ibm.com>, Dan Zerkle <dzerkle_at_us.ibm.com> wrote:
>I want to make a query output a flat-file where every record is a single
>line with the fields separated by commas. I have sqlplus to do this.
>
>So far, the query looks OK. I'm getting the fields as expected, and
>sticking something like ||','|| between them to get the commas. No
>problem there.
>
>I use the -s option for silent output. That gets rid of some garbage.
>
>I use the "set pagesize 0" to get rid of the line breaks for new pages.
>
>I use "set heading off" to get rid of the headings.
>
>Now, though, the output wraps at 80 characters. How do I get rid of
>this? I want each bit of output on a single line, with no blank lines
>between (which happens if a line before wraps). "set wrap off" makes it
>trucate, which is not what I want.
>
>Anything else I should know?

I asked a similar question recently. I think you also want

set linesize <number>	# changes from the default 80 line width
set trimout		# truncates trailing spaces from the terminal output
			#  or
set trimspool		# for spooled output