Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to embed a new line character within the text to be inserted into a VARCHAR2 column?
Galen,
Thanks for the input. It works great.
Simon
Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<uy8i8m3yh.fsf_at_standardandpoors.com>...
> On 15 Oct 2004, scjfan12_at_yahoo.com wrote:
> > Hi,
> >
> > I want to insert multiple lines of text as the data for a cell
> > of type VARCHAR2. How do I embed the new line characters
> > within the text in the INSERT/UPDATE statement?
>
> insert into tbl(varcharcolumn) values ('SOMETHING' || chr(10) || 'ELSE');
Received on Mon Oct 18 2004 - 05:56:45 CDT