Re: How to display multiple line message

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Oct 2002 11:31:25 -0700
Message-ID: <92eeeff0.0210051031.365aa081@posting.google.com>

"Nick" <aroughguy_at_nsp.toughguy.net> wrote in message news:<9_Cn9.12274$Sr6.399198_at_ozemail.com.au>...
> Hi
>
> Without using alert, can we display a multi-line message using Message
> built-in?
>
> I read somewhere on the use of new line ASCII character but could not
> recall. Can someone help remind me?
>
> Thanks
> Nick

In Oracle, CHR(13) is equivalent to DOS Carriage Return (CR). CHR(10) is Linefeed or new line (LF).

In most Windows Multiline fields, you would have to use CRLF to indicate end-of-line e.g. Oracle string '123' || CHR(13) || CHR(10) || '456' will show as
123
456

/Rauf Sarwar Received on Sat Oct 05 2002 - 13:31:25 CDT