Re: How do I insert a CRLF in a String
From: Ulf Magnusson <ulf.magnusson_at_briunix.kiedt.ericsson.se>
Date: Tue, 20 Oct 1998 09:51:55 +0200
Message-ID: <70heqe$2a7_at_newstoo.ericsson.se>
Date: Tue, 20 Oct 1998 09:51:55 +0200
Message-ID: <70heqe$2a7_at_newstoo.ericsson.se>
Hi
I think you have to use thr CHR function.
Try FIELD1 || CHR(13) || CHR(10) || FIELD2
> I would like to know How I can Insert a Carrige return in a string that
>will ultimately end up in a large VARCHAR2
>
>Here is an Exemple:
>
> FIELD1|| 'CR LF'||FIELD2
>
> 'CR LF' Should =be a Line Feed - carriage Retrun...
Received on Tue Oct 20 1998 - 09:51:55 CEST