I have to replace a particular value say "_" with a space in particular column of a table, kindly provide me the query how to achieve this.

Interview Candidate
Dec 7th, 2006
6
2226

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

Gupteshwar

Dec 9th, 2006

You can use REPLACE function in order to replace a digit or character in a column.
SELECT REPLACE(col1, '_', ' ') FROM table_1.
This function can also be used to update column's records.
Try this function. Hope it would work.

Guest

Dec 12th, 2006

Actually your question is not clear. Do u want to change column name or values in the column?to change a values it is quite simple.select replace('replace_underscores_with_spaces','_',' ') from dual;