Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to embed a newline in a PLSQL VARCHAR2
You can use the function named 'chr'
example:
string := 'This string should split'||chr(10)||into two lines';
Use chr(10) or chr(13) depending on OS.
/Olle
Edward Baggott wrote in message ...
>I want to do something like
>
> v_string VARCHAR2(100);
>
> v_string := 'This string should split \ninto two lines';
> DBMS_OUTPUT.PUT_LINE(v_string);
>
>
>This string should be split
>into two lines
>
>
>How to do?
>
>Yrs,
>Ed
>
>
>
Received on Thu Oct 02 1997 - 00:00:00 CDT