Page 1 of 1

oracle sql replace substring(string) in table column

PostPosted: Tue Jan 08, 2013 2:02 pm
by haretu
Use REPLACE:

SELECT REPLACE(t.column, 'est1', 'rest1')
FROM TABLE tIf you want to update the values in the table, use:

UPDATE TABLE
SET column = REPLACE(t.column, 'est1', 'rest1')