Re: How to Add new line character to Varchar2 Field
From: amselvan <amselvan_at_yahoo.com>
Date: 10 Jul 2002 03:53:19 -0700
Message-ID: <7e67ac08.0207100253.f2c2cc0_at_posting.google.com>
Date: 10 Jul 2002 03:53:19 -0700
Message-ID: <7e67ac08.0207100253.f2c2cc0_at_posting.google.com>
Thank you all. That sufficed my requirement
> > 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
> Try using chr(10) for adding newline character
>
> lVar := lVar||chr(10);
>
> This should do the trick.
>
> Good luck
Received on Wed Jul 10 2002 - 12:53:19 CEST