Re: replace VARCHAR2 column substring
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 20:29:58 -0500
Message-ID: <HEiul.15598$as4.13842_at_nlpi069.nbdc.sbc.com>
gareth_at_jamms.org wrote:
> On 12 Mar, 15:22, lora <anjela_..._at_yahoo.com> wrote:
>
> 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
Date: Thu, 12 Mar 2009 20:29:58 -0500
Message-ID: <HEiul.15598$as4.13842_at_nlpi069.nbdc.sbc.com>
gareth_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/functions134.htm#i78608
>
> HTH
>
> -g
are you suggesting that he actually read the "fine" manual? What a concept. Received on Thu Mar 12 2009 - 20:29:58 CDT