Re: replace VARCHAR2 column substring
From: <gareth_at_jamms.org>
Date: Thu, 12 Mar 2009 09:07:01 -0700 (PDT)
Message-ID: <19a53914-325e-43e3-a7fc-7495e0bd7cb9_at_w34g2000yqm.googlegroups.com>
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!
Date: Thu, 12 Mar 2009 09:07:01 -0700 (PDT)
Message-ID: <19a53914-325e-43e3-a7fc-7495e0bd7cb9_at_w34g2000yqm.googlegroups.com>
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/functions134.htm#i78608
HTH -g Received on Thu Mar 12 2009 - 11:07:01 CDT