Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?

From: De DBA <dedba_at_tpg.com.au>
Date: Thu, 02 Sep 2010 10:27:23 +1000
Message-ID: <4C7EEF6B.1010500_at_tpg.com.au>



Linesize only sets the length of one line of output in SQL*Plus. If the value is too long for one line, the output is wrapped onto the next line. It has no influence on the actual amount of bytes retrieved or displayed. The SQL*Plus Users Guide and Reference is quite helpful here ;)

Cheers,

Tony

Bill Myers wrote:
>> "id||id" is 4000 chars concatenated with another 4000 chars, so
>> shouldn't linesize=8000 in that case?
>>
>>
>> On Wed, Sep 1, 2010 at 4:40 PM, Michael Dinh <mdinh_at_xifin.com
>> <mailto:mdinh_at_xifin.com>> wrote:
>>
>> Here is a simple test case. May be I am doing something wrong,
>> but was not able to figure it out.
...<snip>...
>>
>> set linesize 4000

...<snip>...

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 01 2010 - 19:27:23 CDT

Original text of this message