Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: cariage return ?
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Aug 31 1999 - 05:54:42 CDT
![]() |
![]() |