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?
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');
-- Galen BoyerReceived on Fri Oct 15 2004 - 09:52:09 CDT