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

From: Hans Bos <hans.bos_at_xelion.nl>
Date: 2000/04/07
Message-ID: <8ckr44$9v4$1@porthos.nl.uu.net>#1/1

Hello,

Why not put a new line withing quotes.

The following works in oracle 8i:
SQL> select 'first line
  2 next line' from dual;

'FIRSTLINENEXTLINE'

---

first line
next line

Greetings,
Hans.

<tim.mcconechy_at_runtime.dk> wrote in message news:8ck7r5$2a8$1_at_nnrp1.deja.com...
> 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!

--

Received on Fri Apr 07 2000 - 00:00:00 CDT