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

Home -> Community -> Usenet -> c.d.o.tools -> Re: subnstr-function

Re: subnstr-function

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Wed, 18 Jul 2001 14:39:18 GMT
Message-ID: <qch57.966$zY2.12479717@news2.news.adelphia.net>

Use 'instr' to find where the string starts, substr up to that point, put in the replacement, followed by a substr of everything after the replaced string.

"Gomber_at_Home" <sgomber_at_adlink.net> wrote in message news:3B54ABBE.4FDEEF96_at_adlink.net...
> Hi,
> i need some help on generating the right syntax for my specific problem
> - i need to exchange some characters in a string for each appearance in
> the clomn, e.g 'http://182.44.236.3' to 'http://mysite.com' ... i've
> already played around with it for a while but i don't know how to built
> up the command...
>
>
> thanks a lot in advance
>
> Sven
>
>
>
>
Received on Wed Jul 18 2001 - 09:39:18 CDT

Original text of this message

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