Friday, 6 September 2013

Replace string in a column using query in Oracle

Replace string in a column using query in Oracle

In one of my oracle tables, in one column in every row there is a string
'House Name'. I need to replace it with 'House Number'. Can I execute an
update query to find and replace this string in all rows.Or is there any
built in function for that.

No comments:

Post a Comment