Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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?

Re: How to embed a new line character within the text to be inserted into a VARCHAR2 column?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 15 Oct 2004 15:37:41 -0400
Message-ID: <uOydnbDAAJKFuu3cRVn-hQ@comcast.com>

"Alan" <alan_at_erols.com> wrote in message news:2tactqF1tsif5U1_at_uni-berlin.de...
|
| "scjfan122yahoo.com" <scjfan12_at_yahoo.com> wrote in message
| news:1638bead.0410150645.60c98198_at_posting.google.com...
| > 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?
| >
| > Thanks,
| >
| > Simon
|
| It is NOT A CELL!
|
|

a very similar question, with the same terminology, was posted within the past month ('help newbie fromatted ASCII text into cell' on 9/21). i'm wondering if its on somebody's test?

++ mcs Received on Fri Oct 15 2004 - 14:37:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US