Re: Insert Stmt: Text with Carriage return

Daniela Relaford <daniela.relaford_at_danet.de> wrote in news:3B9F49D8.980BC491_at_danet.de:

> Hi,
>
> I'm trying to insert a text into a varchar field using SQL Plus or
> sqlldr.
>
> The text to insert contains carriage returns.
> I've found a way to insert such texts with SQL Plus, but it's rather
> compilcated (insert some character instead of the CR and replace it
> later). Shouldn't there be a simplier way?
>
> Thanks in advance
> Daniela
>

DECLARE

STRING1    	varchar2(32) := 'Line 1';
STRING2     varchar2(32) := 'Line 2';
STRING3     varchar2(32);

BEGIN
STRING3 := STRING1 || CHR(10) || STRING2;

• CHR(10) is actually a LINEFEED which is what I suspect you REALLY want.