Re: replace VARCHAR2 column substring

From: <>
Date: Thu, 12 Mar 2009 09:07:01 -0700 (PDT)
Message-ID: <>

On 12 Mar, 15:22, lora <> 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?

HTH -g Received on Thu Mar 12 2009 - 11:07:01 CDT

Original text of this message