Re: How to put an end of line character in text string

This is in SQL*Plus, I assume.

Try chr(10)

e.g. select 'hello'||chr(10)||'world!'
from dual;

Regards,

Pat.

tim.mcconechy_at_runtime.dk wrote:

> HI!
> How do I put the end of line character at the and of a text string...
> Example:
>
> l_output:=l_output||l_separator||l_columnValue||!WHAT GOES
> HERE!;
>
> l_output is a long variable and I want to
> place multiple lines from here into a LONG field on a table.
>
> All I need to know is how I create the end of line character!
>
> Thanks!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 11 2000 - 00:00:00 CDT