Re: a string with carrige returns

"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message news:<9gvmcc$b9gcv$1_at_ID-70985.news.dfncis.de>...
> Hi,
>
> how can I arrange a string in a PL/SQL-function , which contains carrige
> returns?
>
> Thanks in advance
>
> Andrei

v_variable := v_var2||chr(10);

The chr function returns the ASCII character for the decimal value requested and I am pretty sure 10 = newline and 13 = carriage return. If you are using UNIX you probably want to use newline. DOS text files end in both characters.

• Mark D Powell --