Re: replace VARCHAR2 column substring

From: <gareth_at_jamms.org>
Date: Fri, 13 Mar 2009 03:33:37 -0700 (PDT)
Message-ID: <fee7da5a-22fb-44ee-b8f5-93e327b68a1c_at_p20g2000yqi.googlegroups.com>

On 13 Mar, 01:29, Michael Austin <maus..._at_firstdbasource.com> wrote:
> gar..._at_jamms.org wrote:
> > On 12 Mar, 15:22, lora <anjela_..._at_yahoo.com> wrote:
> >> Hello all,
>
> >> What is the easiest way to replace part of a string in a VARCHAR2
> >> column with another string?
>
> >> My strings span multiple lines and I just need to replace one string
> >> with another.
>
> >> Is there an SQL command to do this w/o requiring a procedure?
>
> >> I'm on Oracle10g and my client is TOAD. TOAD lets me run any valid SQL
> >> command.
>
> >> Thank you!
>
> > I'm not sure what you mean when you say that a VARCHAR2 datatype spans
> > multiple lines.  However, is the REPLACE function any use to you?
>
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functi...
>
> > HTH
>
> > -g
>
>   are you suggesting that he actually read the "fine" manual? What a
> concept.

I figured I'd teach the OP to fish rather than just spoon-feed :)

-g Received on Fri Mar 13 2009 - 05:33:37 CDT