读书人

oracle转义符的剔除

发布时间: 2012-07-05 07:59:18 作者: rapoo

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;

读书人网 >其他数据库

热点推荐