Re: EOL character

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/05/18
Message-ID: <8fvhu3$r62$1@perki.connect.com.au>#1/1

There are few of them around.!!!

1- chr(13)
SQL> select 'this is a test'||chr(13)||' this is a test' from dual;

'THISISATEST'||CHR(13)||'THISI

---

this is a test
 this is a test

  1* select 'this is a test'||chr(10)||' this is a test' from dual SQL> / 'THISISATEST'||CHR(10)||'THISI

---

this is a test
 this is a test

also you could do

declare
new_line char(2);
begin
new_line:='
';
dbms_output.put_line('This is a new line'||new_line||this is newline'); end;
/

Tom
Wojciech Grupa <wgrupa_at_lucent.com> wrote in message news:3922D3A2.DF7C60A0_at_lucent.com...
> Hi,
>
> Can anyone tell me what is end-of-line character in PLSQL. I need to have:
>
> txt varchar2(2000)
>
> txt := 'some text' || EOL || 'some text'
>
> thanks,
>
> Wojtek
Received on Thu May 18 2000 - 00:00:00 CDT