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: <Gomber_at_Home>
Date: Wed, 18 Jul 2001 19:21:10 +0200
Message-ID: <3B55C586.D14D4B04@adlink.net>

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

Original text of this message

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