Re: New lines in a string variable

You can concatenate a NL to a string by using CHR(10).

Like: str_a := 'This is line 1.'||CHR(10)||'This is line 2.'||CHR(10);

Edmund Lou wrote:
>
> Is it possible to insert some type of newline character into a
> string variable such as LONG? I need it so that another application
> or Oracle will interpret these newline indicators and will indeed
> print it out as such when, say you query the LONG variable.
>
> Thanks.
>
> ---
> Edmund Lou
  Received on Thu Aug 14 1997 - 00:00:00 CDT