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

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert Multiple Lines into long or varchar2 field

Re: Insert Multiple Lines into long or varchar2 field

From: Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br>
Date: Thu, 17 Jun 2004 17:27:24 -0300
Message-ID: <5jv3d053rmb9q71hurs6gj0s9jjbiqorf2@4ax.com>


On 17 Jun 2004 10:18:42 -0700, wangxianlg_at_yahoo.com (Alan) wrote:

>How can I insert Multiple Lines into long or varchar2 field and when
>application gets data back also in Multiple Lines format.
>
>Thanks in advance
>
>Alan

CHR(10) breaks the line.
Depends on the application to retrieve correctly. On Oracle Forms, just set the property "multiline" to yes.

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net
Received on Thu Jun 17 2004 - 15:27:24 CDT

Original text of this message

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