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: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 2 Mar 2004 10:24:29 -0800
Message-ID: <4b5394b2.0403021024.239ec758@posting.google.com>

"George Ziniewicz" <zin1_at_cox.net> wrote in message news:<TbR0c.5733$506.5243_at_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

Stop doing his homework!

ed Received on Tue Mar 02 2004 - 12:24:29 CST

Original text of this message

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