转义
function replace_string_json(p_string in varchar2) return varchar2 is
l_temp varchar2(30000);
begin
l_temp := p_string;
l_temp := replace(l_temp, '\', '\\');
l_temp := replace(l_temp, '"', '\"');
l_temp := replace(l_temp, '&', '&');
l_temp := replace(l_temp, '<', '<');
l_temp := replace(l_temp, '>', '>');
l_temp := replace(l_temp, '‘', ''');
l_temp := replace(l_temp, '’', ''');
l_temp := replace(l_temp, '“', '"');
l_temp := replace(l_temp, '”', '"');
return l_temp;
end replace_string_json;
标签：return,string,temp,replace,varchar2,Oracle,转义,特殊字符 From： https://www.cnblogs.com/ivenlin/p/18121690