Is it possible to replace a character within set of oracle records with update statement

I need replace all  semi-colons with comma in a set of oracle reocrds in a particular field.  Is there a way to change an item in a record vs change the record.?

gilnariAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You are not replacing the column name.  You are replacing the data stored in the column.

As always, set up a quick test and test things.

Create table tab1(col1 varchar2(20));
Insert into tab1 values('john; smith');
Update tab1 set col1=replace(col1,';',',');
Select * from tab1;
0
 
slightwv (䄆 Netminder) Commented:
If I understand this correctly it is a simple update:
update table_name set column_name=replace(column_name,';',',');
0
 
gilnariAuthor Commented:
I don't want to replace the column name,  I want to update a set of records where as example

john; smith
susize; cole

to
john, smith
susize, cole

0
 
gilnariAuthor Commented:
I love you guys and gals.  thank you again
0
 
slightwv (䄆 Netminder) Commented:
As always: glad to help.
0
All Courses

From novice to tech pro — start learning today.