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