Re: sqlplus clean output?

Have you tried
set linesize?
set feedback off
set spooltrim on

Dan Zerkle <dzerkle_at_us.ibm.com> wrote in message news:382B3BFF.6A55D564_at_us.ibm.com...
> 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?
Received on Fri Nov 12 1999 - 05:05:33 CET