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>
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>
用replace(fld,'''','')替换单引号'
用replace(str,'''','')替换单引号'