这将删除string1中每个字符的所有出现:
SELECT translate(
translate(
translate(string1, CHR(10), '')
, CHR(13), '')
, CHR(09), '') as massaged
FROM BLAH;
在Oracle中的字符串中修剪空白(换行和制表符空间)
这将删除string1中每个字符的所有出现:
SELECT translate(
translate(
translate(string1, CHR(10), '')
, CHR(13), '')
, CHR(09), '') as massaged
FROM BLAH;