plsql中特殊字符的处理

--去除换行chr(10)
update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(10),'');
--去掉回车chr(13)
update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(13),'');
--去掉空格chr(32)
update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(32),'');
--去掉两边空白trim()
update zhzl_address t set t.add_administration_num=trim(t.add_administration_num);
--特殊符号ascii定义
--制表符 chr(9)
--换行符 chr(10)
--回车符 chr(13)
附上ASCII码: