SQL> CREATE TABLE t (addr VARCHAR2(20));
  
Table created.
  
SQL> INSERT INTO t VALUES ('1234 asdfgh ap.');
  
1 row created.
  
SQL> INSERT INTO t VALUES ('567 E. asdfgh');
  
1 row created.
  
SQL> INSERT INTO t VALUES ('234 asdfgh ap');
  
1 row created.
  
SQL> COMMIT;
  
Commit complete.
  
SQL> <font color=blue>UPDATE t</font>
  2  <font color=blue>SET    t.addr = REPLACE(t.addr</font>
  3  <font color=blue>                ,       'asdfgh'</font>
  4  <font color=blue>                ,       'asd fgh')</font>
  5  <font color=blue>WHERE  INSTR(t.addr</font>
  6  <font color=blue>       ,     'asdfgh') > 0;</font>
  
3 rows updated.
  
SQL> COMMIT;
  
Commit complete.
  
SQL> SELECT addr FROM t;
  
ADDR
--------------------
1234 asd fgh ap.
567 E. asd fgh
234 asd fgh ap
  
SQL>