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: HELP ASP (ORACLE V7 + EXCEL)

Re: HELP ASP (ORACLE V7 + EXCEL)

From: Kapil Madan <kapil.madan_at_in.bosch.com>
Date: 10 Mar 1999 17:35:38 GMT
Message-ID: <01be6b1c$6c0e85e0$140394ad@qcs20.ban.india.bosch.com> 







How can I remove this carriage-return (which causes a


> problem when I recover my file in Excel) of my fields varchar2. With


> PL/SQL or SQL??? how??





try using  replace( field_name,CHR(10)) in the select statement
 where field_name is the name 


of the varchar2 field which contains the carriage return



Kapil
Received on Wed Mar 10 1999 - 11:35:38 CST












Original text of this message













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