ORACLE 回车换行符

定义

制表符 chr(9)
换行符 chr(10)
回车符 chr(13)

查询

SELECT 'AA' || chr(9) || 'BB' || chr(10) || 'CC' || chr(13) || 'DD' as A FROM DUAL;

替换

SELECT 'AA    BB
CC
DD', TRANSLATE('AA    BB
CC
DD', CHR(9)||CHR(10)||CHR(13), ',-') FROM dual;