From: Luc Bosman <l.bosman@wanadoo.be>
Subject: Re: Linefeed
Date: 2000/06/06
Message-ID: <vuppjs4fa6ehnr6tm7tbvv795kbrr4ukn0@4ax.com>#1/1
Content-Transfer-Encoding: 8bit
References: <j_4%4.20737$C9.394353@news1.online.no>
Content-Type: text/plain; charset=ISO-8859-1
X-Complaints-To: The appropriate party according to NNTP-Posting-Host:
X-Trace: buty.wanadoo.nl 960293108 62489 212.65.53.183 (6 Jun 2000 12:05:08 GMT)
Organization: EuroNet Internet
Mime-Version: 1.0
Reply-To: l.bosman@wanadoo.be
NNTP-Posting-Date: 6 Jun 2000 12:05:08 GMT
Newsgroups: comp.databases.oracle.tools


On Tue, 6 Jun 2000 13:10:01 +0200, "Stian Kaasa" <stian.kaasa@caa.no>
wrote:

>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--);
>
:NEW.HISTORY := :NEW.HISTORY || chr(10)

chr() is a function converting a number to a character fellowing the
ascii code.
ascii() is the opposite function


-- 
Luc Bosman
DEV/2000 Software Engineer
Database and Network Administrator
l.bosman@wanadoo.be
ICQ 37011625          http://users.skynet.be/kobukai/
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------