sqlplus clean output?

From: Dan Zerkle <dzerkle_at_us.ibm.com>
Date: Thu, 11 Nov 1999 16:58:24 -0500
Message-ID: <382B3BFF.6A55D564_at_us.ibm.com>

[Quoted] [Quoted] I want to make a query output a flat-file where every record is a single [Quoted] 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 Thu Nov 11 1999 - 22:58:24 CET