oracle sql replace substring(string) in table column

Commonly used J2EE server side frameworks.

oracle sql replace substring(string) in table column

Postby haretu » Tue Jan 08, 2013 2:02 pm

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')
haretu
 
Posts: 132
Joined: Sat Jan 08, 2011 9:56 pm

Return to struts,spring,hibernate

Who is online

Users browsing this forum: No registered users and 0 guests

cron