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
This is good, but a simple way would be to do this...
v_string := 'This string should split
into two lines';
This will create the correct split desired...
Cheers, Fred
Jomarlen wrote in message <19971001160301.MAA12303_at_ladder01.news.aol.com>...
>Try
>v_string := 'This string should split '||chr(10)||'into two lines';
>
>John
Received on Sun Oct 05 1997 - 00:00:00 CDT
![]() |
![]() |