關鍵字:replace,dbms_lob.instr
第一步:判斷clob里面是有包含某個特定的字符串:假如是說“/admin/ewebeditor/uploadfile/“
關鍵字:dbms_lob.instr
Code:
select st.id,st.content
from t_d_strategy st where dbms_lob.instr(st.content,'/admin/ewebeditor/uploadfile/') > 0;
第二步:用replace先替換下看是否是自己想要的結果
關鍵字:replace
Code:
select st.id,replace(st.content,'/admin/ewebeditor/uploadfile/','E:/resource/images/uploadfile/')
from t_d_strategy st where st.id = 553 and dbms_lob.instr(st.content,'/admin/ewebeditor/uploadfile/') > 0;
第三步:替換,前面的兩步ok,肯定錯不了的
關鍵字:update set
Code:
update t_d_strategy st set st.content = replace(st.content,'/admin/ewebeditor/uploadfile/','E:/resource/images/uploadfile/')
where st.id = 553 and dbms_lob.instr(st.content,'/admin/ewebeditor/uploadfile/') > 0;