无题

update action_c_clob set largeinput=ltrim(substr(largeinput,instr(largeinput,'@#$%%%%%',1,1)+9,length(largeinput)-instr(largeinput,'@#$%%%%%',1,1)-9))
where action_id=8

update action_c_clob set largeinput=ltrim(substr(largeinput,2,length(largeinput)-1)) where action_id=8

posted on 2009-06-08 09:54  dhj  阅读(88)  评论(0编辑  收藏  举报

导航