Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cariage return ?

Re: cariage return ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 31 Aug 1999 18:54:42 +0800
Message-ID: <37CBB472.7E4@yahoo.com>


benoit guyon wrote:
>
> hello
> I' have this problem :
> i store text in oracle for a multiline text box (power++ - microsoft
> platform), and i want to make a pl/sql procedure with this code :
>
> txtstr:=concat(txtstr,'\r\n');
>
> but, of course, it doesn't work :)
> does anybody knows how to insert a 'cariage return - line feed' under
> pl/sql ?
> thanks in advance
>
> guyon benoit -- bguyon_at_polydeme.fr
> société polydeme -- http://www.polydeme.fr
> Salut ! Je suis un virus de signature :) Mettez-moi dans la vôtre.
> "Any technology distinguishable from magic is insufficiently advanced."

Try using chr(10) for carriage returns
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Aug 31 1999 - 05:54:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US