Brian Tkatch wrote:
> 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.
C'est dommage.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 29 2007 - 10:11:38 CST
