oracle转义符的删除update taoke set titlereplace(title,span class&,##) where id2commitupda
oracle转义符的删除
update taoke set title=replace(title,'<span class=&','##') where id=2;
commit;
update taoke set title=replace(title,'quot;H&','##') where id=2;
commit;
update taoke set title=replace(title,'quot;>','##') where id=2;
commit;
update taoke set title=replace(title,'</span>','##') where id=2;
commit;
update taoke set title=replace(title,'######','') where id=2;
commit;
update taoke set title=replace(title,'##','') where id=2;
commit;
