SELECT 
REGEXP_REPLACE(tbgc_description,'[[:cntrl:]]','')
FROM zdoe_tbgc_subbill
;

------解决方案--------------------
SQL code
WITH t AS (
SELECT 
'1aaa '||chr(13)||
'2bbb '||chr(13)||
'3ccc ' id FROM dual
)
select id from t
output:
1aaa 
2bbb 
3ccc 
SELECT REPLACE(id,Chr(13),'') FROM t;
output:
1aaa 2bbb 3ccc

------解决方案--------------------
SQL code
SQL> select * from zdoe_tbgc_subbill;
 
TBGC_DESCRIPTION
--------------------------------------------
1)采用AI-11电脑(电子尺控制)
2)配油研SVP伺服装置
3)T型槽模板(含T型槽螺栓)
SQL> select replace(wm_concat(tbgc_description),',') from zdoe_tbgc_subbill t;
 
REPLACE(WM_CONCAT(TBGC_DESCRIP
--------------------------------------------
1)采用AI-11电脑(电子尺控制)2)配油研SVP伺服装置3)T型槽模板(含T型槽螺栓)
 
SQL>