Re: sqlplus clean output?

Dan,

Try this:

    set linesize 100 (or anything longer than the record length)     set trimspool on (to remove blanks from the end of the line in the spool file)

On Thu, 11 Nov 1999 16:58:24 -0500, 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?
Received on Fri Nov 12 1999 - 07:17:12 CET