From: "Michel Cadot" <micadot@netcourrier.com>
Subject: Re: Linefeed
Date: 2000/06/06
Message-ID: <8hip38$142d$1@s2.feed.news.oleane.net>#1/1
References: <j_4%4.20737$C9.394353@news1.online.no>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@oleane.net
X-Trace: s2.feed.news.oleane.net 960292778 36941 195.101.229.231 (6 Jun 2000 11:59:38 GMT)
Organization: Guest of France Telecom Oleane's newsreading service
Reply-To: "Michel Cadot" <micadot@netcourrier.com>
NNTP-Posting-Date: 6 Jun 2000 11:59:38 GMT
Newsgroups: comp.databases.oracle.tools


You can use a LF in the string:
:NEW.HISTORY := :NEW.HISTORY || '
...';
or the CHR function:
:NEW.HISTORY := :NEW.HISTORY || chr(10) || '...';

--
Have a nice day
Michel


Stian Kaasa <stian.kaasa@caa.no> a écrit dans le message : j_4%4.20737$C9.394353@news1.online.no...
> Hi
>
> Does anyone know how to insert Line Feeds into a text ?
> Example:  :NEW.HISTORY := CONCAT(:NEW.HISTORY,--want an escape sequence for
> LF here--);
>
> Appreciate any help
>
> Stian Kaasa
>
>