替换字段中回车换行字符

select regexp_replace(lg,'\\n|\\r|\\t|\\s+','') from spd_trancare_mid.mapping_lg_desc