t1 table
--------------
colId   |col1
--------|------
Integer |Clob
-------------

UPDATE MYTABLE
    SET MyClobField =
             SUBSTR (MyClobField, 1, 10)
          || TO_CLOB ('MyNewtext')
          || SUBSTR (MyClobField, 10 + LENGTH ('MyNewtext') + 1)
     where..