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 -> Help! RTRIM keep running

Help! RTRIM keep running

From: Sunit Joshi <sjoshi_at_ingr.com>
Date: 10 Dec 2001 14:58:08 -0800
Message-ID: <8f8ffe67.0112101458.3617e0a@posting.google.com> 





Hello All


I have a table pdtable with a coln pipe_support_no which is char(20).
It has entries like s1-c1", S2-C2" so on. I need to remove the " from
the end, so I tried this


update pdtable set pipe_support_no = rtrim(pipe_support_no,'"')



But the update process keeps on running with no apparent results and I
have kill the window. Any ideas what might be wrong here ???




thanks


Sunit
Received on Mon Dec 10 2001 - 16:58:08 CST












Original text of this message













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