1.逗号替换成'逗号'
replace(xxx,',',''',''')
2.字符串两天拼接单引号
'''' || replace(xxx,',',''',''') || ''''
select '''' || replace(col_name ,',',''',''') || '''' as col_name2 from t_pur_process where id='dcbaa4feb67b443588b0f6c58b181b69'
1.逗号替换成'逗号'
replace(xxx,',',''',''')
2.字符串两天拼接单引号
'''' || replace(xxx,',',''',''') || ''''
select '''' || replace(col_name ,',',''',''') || '''' as col_name2 from t_pur_process where id='dcbaa4feb67b443588b0f6c58b181b69'