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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: remove character...

Re: remove character...

From: George Ziniewicz <zin1_at_cox.net>
Date: Mon, 1 Mar 2004 18:16:48 -0800
Message-ID: <TbR0c.5733$506.5243@fed1read05> 






"Marc Collin" <os2_at_videotron.ca> wrote in message
news:NKM0c.63859$QM4.1041253_at_weber.videotron.net...


> hi

>

> with plsql

> how to Remove N character in str1 starting from index I




   haven't tried it but it looks ok:



   newStr=

      substr(orig_str,1,I-1)||
      substr(orig_str,I+N);





zin


---  http://www.zintel.com
Received on Mon Mar 01 2004 - 20:16:48 CST












Original text of this message













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