Re: How to Add new line character to Varchar2 Field
From: Alex Holt <ah_5020_at_yahoo.co.uk>
Date: 9 Jul 2002 02:49:57 -0700
Message-ID: <80d3e19b.0207090149.76b828ad_at_posting.google.com>
Date: 9 Jul 2002 02:49:57 -0700
Message-ID: <80d3e19b.0207090149.76b828ad_at_posting.google.com>
<your string>||char(10)||<rest of message>
the double pipe (||) concatenates strings. the char function returns character with supplied value (10 = new line for linux/unix) for windows/dos you'll have to concatenate char(10)||char(13)
amselvan_at_yahoo.com (amselvan) wrote in message news:<7e67ac08.0207080756.55bf2c5f_at_posting.google.com>...
> Hi,
> I need to insert a string with newline characters in it.
> How will i do that in PL/SQL.
> Thanks for any answers
> Regards,
> amselvan
Received on Tue Jul 09 2002 - 11:49:57 CEST