Re: Does CHR(10) add an extra newline?

On Wed, 21 Nov 2007 19:48:11 +0100, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>Brian Tkatch wrote:
>> While writing a query to do some editting i wanted to use CHR(10) to
>> have a query do some formatting. It seems that whenever it is used, it
>> adds an extra newline at the end of the line.
>>
>>
>> SQL> SELECT RowNum A, CHR(10) || RowNum B FROM (SELECT * FROM Dual
>> CONNECT BY LEVEL < 4)
>
>No - your display simply is not wide enough.

My linesize is set to 156, which does not wordwrap normally.

B.

>Why don't you check out all possible settings in SQL*Plus?
>the one you want is SET LINES[ize]
Received on Wed Nov 21 2007 - 13:49:12 CST