How to replace specific values in a oracle database column

Question

I am looking to replace values in a particular column  For example the following column values  column name ---------- Test1 Test2 Test3 Test12   should be  replacing est1 with rest1   column name ---------- Trest1 Test2 Test3 Trest12

User · Accepted Answer

Use REPLACE   SELECT REPLACE t column   est1    rest1     FROM MY TABLE t   If you want to update the values in the table  use   UPDATE MY TABLE t    SET column   REPLACE t column   est1    rest1

User · Answer

If you need to update the value in a particular table   UPDATE TABLE-NAME SET COLUMN-NAME   REPLACE TABLE-NAME COLUMN-NAME   STRING-TO-REPLACE    REPLACEMENT-STRING      where     TABLE-NAME         - The name of the table being updated   COLUMN-NAME        - The name of the column being updated   STRING-TO-REPLACE  - The value to replace   REPLACEMENT-STRING - The replacement

User · Answer

I m using Version 4 0 2 15 with Build 15 21  For me I needed this   UPDATE table name SET column name   REPLACE column name  search str   replace str      Putting t column name in the first argument of replace did not work

User · Answer

In Oracle  there is the concept of schema name  so try using this  update schemname tablename t set t columnname   replace t columnname  t oldvalue  t newvalue

[sql] How to replace specific values in a oracle database column?

Examples related to sql

Examples related to oracle

Examples related to replace