如何去掉数据中的回车键、撇号？

12:51:06 SQL> select 'awefawe
12:51:18   2  wfew' from dual;'AWEFAWEWFEW
------------
awefawe
wfew
已用时间:  00: 00: 00.32
12:51:22 SQL> select replace('awefawe
12:51:59   2  wfew',chr(10),'') from dual;REPLACE('AW
-----------
awefawewfew已用时间:  00: 00: 00.31
12:52:00 SQL> select 'weofawefga''wefa' from dual;'WEOFAWEFGA''WE
---------------
weofawefga'wefa已用时间:  00: 00: 00.47
12:52:32 SQL> select replace('weofawefga''wefa','''','') from dual;REPLACE('WEOFA
--------------
weofawefgawefa已用时间:  00: 00: 00.31
12:52:50 SQL>