就是不太会转义符 select replace('aaaa,vvvv,ddd', ',',',') from dual 这怎么转义啊
这种情况用replace就好了,很简单的,试试下面的语句就知道了select '''ABC,ABCD,FDE''' orig, replace('''ABC,ABCD,FDE''',',',''',''') result from dual; ORIG RESULT -------------- ------------------ 'ABC,ABCD,FDE' 'ABC','ABCD','FDE'
select ''''||replace('aaaa,vvvv,ddd', ',',''',''')||'''' a from dual
select replace('aaaa,vvvv,ddd', ',',',') from dual
这怎么转义啊
ORIG RESULT
-------------- ------------------
'ABC,ABCD,FDE' 'ABC','ABCD','FDE'