918   Oracle

一,特殊符号
制表符 chr(9)
换行符 chr(10)
回车符 chr(13)

二、通过repalce替换

select REPLACE(str, chr(10), '') from dual



Leave a Reply

Your email address will not be published. Required fields are marked *