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

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/04/13
Message-ID: <8d5987$2t0$1@plo.sierra.com>#1/1

SQL> select '[Hello ' || '
  2 ]' from dual;

'[HELLO'|

---

[Hello
]

notice that I left a single quote on the end of the "select...", placed another single quote on the next line to finish with from dual.

"Pat Boivin" <lori.pat_at_ns.sympatico.ca> wrote in message news:38F29C46.A5C47B16_at_ns.sympatico.ca...
> 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 Thu Apr 13 2000 - 00:00:00 CDT