update table_wonder set tempcolumn = dbms_lob.substr(clobcolumn,4000);

//追加列

  update cms_info_relation r  set r.info_content_test= info_content_test||'.doc'  where info_id
  in(select i.info_id  from cms_info i  
  where i.info_type=4);