oracle中制表符,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;

原文：http://www.cnblogs.com/xunianchong/p/4650416.html