Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: subnstr-function
Hello Scott
Scott Mattes wrote:
> 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
since i'm still very new on that stuff how would you set up the syntax for your example if you have to exchange the following:
http://a1168/f/h/solution.net/184.96.244.3/Switzerland/Crossair/QFGE.gif where 184.96.244.3 should be replaced with mysite.com ?
thanks for your help
Sven Received on Wed Jul 18 2001 - 12:21:10 CDT
![]() |
![]() |