oracle替换文本中的换行符、回车符、制表符

特殊符号ascii定义
 制表符 chr(9) 
 换行符 chr(10)
 回车符 chr(13)

select replace(replace(replace('111111111111' || chr(10) ||                               '22222222222222222' || chr(13) ||                               '333333333' || chr(10) || '444444444444' ||                               chr(9) || '5555555555',                               chr(10),                               ''),                       chr(13),                       ''),               chr(9),               '')  from dual