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 -> line breaks and tabs in a varchar2 column

line breaks and tabs in a varchar2 column

From: Sean Welsh <seanw_at_order.com.au>
Date: Fri, 13 Oct 2000 17:14:36 +1000
Message-ID: <tJxF5.137$gD.4518@nsw.nnrp.telstra.net> 






Dear All,



I have a table which has descriptions of items in a varchar2(2000) column (v
8.1.5 sparc solaris).



Some of these seem to have line breaks and tabs in them.



Is there an easy way to get rid of them using SQL or by other means?



Regards,



Sean Welsh
Received on Fri Oct 13 2000 - 02:14:36 CDT












Original text of this message













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