replace VARCHAR2 column substring

From: lora <>
Date: Thu, 12 Mar 2009 08:22:41 -0700 (PDT)
Message-ID: <>

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! Received on Thu Mar 12 2009 - 10:22:41 CDT

Original text of this message