clob字段替换 replace(x,y,z)返回为将串x中的y串用z串替换后的结果字符串。若省略z参数，则将串x中为y串的地方删除 update ypgcxx.t_article_info st set st.f_content = replace(st.f_content,'/portal/','/ypgcxx/') where dbms_lob.instr(st.f_content,'/
clob字段值替换
replace(x,y,z)返回值为将串x中的y串用z串替换后的结果字符串。若省略z参数，则将串x中为y串的地方删除
update ypgcxx.t_article_info st set st.f_content =  replace(st.f_content,'/portal/','/ypgcxx/') where   dbms_lob.instr(st.f_content,'/portal/') > 0;
commit;
--按条件检索clob字段内容
select st.f_content from qzxyfszx.t_article_info st where   dbms_lob.instr(st.f_content,'/qyfz/')>0
update qzxyfszx.t_article_info st set st.f_content =  replace(st.f_content,'/qhcwwmzx/','/qyfz/') where   dbms_lob.instr(st.f_content,'/qhcwwmzx/')>0
select st.f_content from tchqxx.t_article_info st where   dbms_lob.instr(st.f_content,'/tchqxx/')>0
update tchqxx.t_article_info st set st.f_content =  replace(st.f_content,'/tchqxx/','/tcxhqxx/') where   dbms_lob.instr(st.f_content,'/tchqxx/')>0;
commit;
select st.f_content from tchqxx.t_article_info st where   dbms_lob.instr(st.f_content,'/tcxhqxx/')>0