oracle中去掉文本中的换行符、回车符、制表符
一、特殊符号ascii定义
制表符 chr(9)
换行符 chr(10)
回车符 chr(13)
UPDATE tc_car_order set USE_REASON = REPLACE('USE_REASON',chr(9),'');
UPDATE tc_car_order set USE_REASON = REPLACE('USE_REASON',chr(10),'');
UPDATE tc_car_order set USE_REASON = REPLACE('USE_REASON',chr(13),'');
UPDATE tc_car_order set SPECIAL_REMARK = REPLACE('USE_REASON',chr(9),'');
UPDATE tc_car_order set SPECIAL_REMARK = REPLACE('USE_REASON',chr(10),'');
UPDATE tc_car_order set SPECIAL_REMARK = REPLACE('USE_REASON',chr(13),'');
SELECT REPLACE('accdbbgg',chr(9),'') from dual;
SELECT REPLACE('accdbbgg',chr(10),'') from dual;
SELECT REPLACE('accdbbgg',chr(13),'') from dual;
posted on 2015-07-16 10:15 xunianchong 阅读(1707) 评论(0) 编辑 收藏 举报