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

On Wed, 28 Nov 2007 13:32:26 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>Brian Tkatch wrote:
>> On Tue, 27 Nov 2007 19:45:16 -0800, DA Morgan <damorgan_at_psoug.org>
>> wrote:
>>
>>> Brian Tkatch wrote:
>>>> On Thu, 22 Nov 2007 04:32:22 -0800 (PST), Frank van Bortel
>>>> <frank.van.bortel_at_gmail.com> wrote:
>>>>
>>>>> On 21 nov, 20:53, Brian Tkatch <N/A> wrote:
>>>>>> On Wed, 21 Nov 2007 11:40:24 -0800 (PST), "fitzjarr..._at_cox.net"
>>>>>>
>>>>>>
>>>>>>
>>>>>> <fitzjarr..._at_cox.net> wrote:
>>>>>>> On Nov 21, 12:48 pm, Frank van Bortel <frank.van.bor..._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.
>>>>>>>> Why don't you check out all possible settings in SQL*Plus?
>>>>>>>> the one you want is SET LINES[ize]
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Frank van Bortel
>>>>>>>> Top-posting is one way to shut me up...
>>>>>>> I return the same results that you posted, using 10.2.0.3.0 on AIX:
>>>>>>> SQL> SELECT RowNum A, CHR(10) || RowNum B FROM (SELECT * FROM Dual
>>>>>>> 2 CONNECT BY LEVEL < 4);
>>>>>>> A B
>>>>>>> -- -----------------------------------------
>>>>>>> 1
>>>>>>> 1
>>>>>>> 2
>>>>>>> 2
>>>>>>> 3
>>>>>>> 3
>>>>>>> no matter how long my linesize. Also the method of introducing the
>>>>>>> chr(10) into the text matters not:
>>>>>>> SQL> variable lf varchar2
>>>>>>> SQL> exec :lf := chr(10);
>>>>>>> PL/SQL procedure successfully completed.
>>>>>>> SQL> select rownum a, :lf||rownum b
>>>>>>> 2 from dual
>>>>>>> 3 connect by level < 4;
>>>>>>> A B
>>>>>> Thank you. I came up with it originally in a CASE statement, to create
>>>>>> CREATE VIEW statements. I worked around it by opening Word, and doing
>>>>>> a replace on ",^p^p". Though, i am quite curious why this is
>>>>>> happening.
>>>>>>
>>>>>> And thanx for the example in PL/SQL.
>>>>>>
>>>>>> B.
>>>>> You normally would not create views "on the fly"...
>>>>> Apart from that - there's no need for carriage returns in DDL,
>>>>> but if you really want them, just embed the carriage return in the
>>>>> statement:
>>>>>
>>>>> SQL> select 'hello
>>>>> 2 world' from dual;
>>>>>
>>>>> 'HELLOWORLD'
>>>>> ------------
>>>>> hello
>>>>> world
>>>>>
>>>>> And yes- there's an extra space before Hello on line 2.
>>>> This does not help, there is still an extra CR after the line.
>>>>
>>>> SQL>select 'hello
>>>> 2 world' from (SELECT * FROM Dual CONNECT BY Level < 3);
>>>>
>>>> 'HELLOWORLD'
>>>> ------------
>>>> hello
>>>> world
>>>>
>>>> hello
>>>> world
>>>>
>>>>
>>>> SQL>
>>>>
>>>> B.
>>> Do you remember how do you remove a trailing character from a string?
>>> If so consider using it.
>>
>> Weren't you going to killfile me?
>>
>> If you have nothing useful to say, please keep it to yourself.
>>
>> B.
>
>Killed the thread not you. But if you'd like I'd be happy to do so.

I'd very much like you too. Most of your responses to me are useless and aggrivating. But to others, your signal to noise ration is still good.

B. Received on Thu Nov 29 2007 - 08:18:23 CST