replace VARCHAR2 column substring

#1

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!

#2

On 12 Mar, 15:22, lora <anjela_... (AT) yahoo (DOT) com> wrote:

Quote:

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/B...134.htm#i78608

HTH

-g

#3

gareth (AT) jamms (DOT) org wrote:

Quote:

On 12 Mar, 15:22, lora <anjela_... (AT) yahoo (DOT) 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/B...134.htm#i78608

HTH

-g

are you suggesting that he actually read the "fine" manual? What a
concept.

#4

On 13 Mar, 01:29, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:

Quote:

gar... (AT) jamms (DOT) org wrote:
On 12 Mar, 15:22, lora <anjela_... (AT) yahoo (DOT) 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/B.../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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

replace VARCHAR2 column substring

comp.databases.oracle.misc comp.databases.oracle.misc

replace VARCHAR2 column substring - 03-12-2009 , 09:22 AM

Re: replace VARCHAR2 column substring - 03-12-2009 , 10:07 AM

Re: replace VARCHAR2 column substring - 03-12-2009 , 07:29 PM

Re: replace VARCHAR2 column substring - 03-13-2009 , 04:33 AM