In article <9pc8eg$1b72$1_at_news6.isdnet.net>, "DBA says...
>
>Hi,
>
>Someone could tel me how can i do to insert a NewLine Character in a :
>
>select "myString," || NewLine || myString2 from toto;
>
>result is : myString,
> myString2
>
>Thank's
>
>
use chr(10) which is the linefeed character (newline). chr(13)||chr(10) on DOS
(but char(10) typically does it just as well)
--
Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Tue Oct 02 2001 - 08:05:31 CDT
