Re: How to Add new line character to Varchar2 Field
From: Aravind <rfjam4_at_yahoo.com>
Date: 9 Jul 2002 08:19:39 -0700
Message-ID: <6f1f2925.0207090719.6ddfb177_at_posting.google.com>
Date: 9 Jul 2002 08:19:39 -0700
Message-ID: <6f1f2925.0207090719.6ddfb177_at_posting.google.com>
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
Try using chr(10) for adding newline character
lVar := lVar||chr(10);
This should do the trick.
Good luck Received on Tue Jul 09 2002 - 17:19:39 CEST