如何替换oracle数据库列中的特定值?

使用 REPLACE :

SELECT REPLACE(t.column, 'est1', 'rest1')
  FROM MY_TABLE t

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

如果需要更新特定表中的值:

UPDATE TABLE-NAME SET COLUMN-NAME = REPLACE(TABLE-NAME.COLUMN-NAME, 'STRING-TO-REPLACE', 'REPLACEMENT-STRING');

哪里

  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

update schemname.tablename t
set t.columnname = replace(t.columnname, t.oldvalue, t.newvalue);

我正在使用版本4.0.2.15和内部版本15.21

对我来说,我需要这个:

UPDATE table_name SET column_name = REPLACE(column_name,"search str","replace str");

放 t.column_name replace