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