日期:2014-05-16  浏览次数:20485 次

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;