select replace(replace(A,chr(10),''),' ','') from ( select 'a b c d e' A from dual )--chr(10)判断回车 --' '判断空格--result: abcde
ascii() replace() 先用ascii()函数得到你要去掉的字符的asc码,如select ascii(' ') from dual;得到空格的asc码,再用replace()函数替换,已知空格的asc码为32,就可以select repace(字段,chr(32),'') from tname
select regexp_replace('a'||chr(10)||'b c','[[:space:]]','') a from dual
from
(
select 'a b c
d
e' A from dual
)--chr(10)判断回车
--' '判断空格--result:
abcde
replace()
先用ascii()函数得到你要去掉的字符的asc码,如select ascii(' ') from dual;得到空格的asc码,再用replace()函数替换,已知空格的asc码为32,就可以select repace(字段,chr(32),'') from tname