Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: subnstr-function
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