Oracle 特殊字元轉義

轉義

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, '<', '&lt;');
    l_temp := replace(l_temp, '>', '&gt;');
    l_temp := replace(l_temp, '‘', '&apos;');
    l_temp := replace(l_temp, '’', '&apos;');
    l_temp := replace(l_temp, '“', '&quot;');
    l_temp := replace(l_temp, '”', '&quot;');
    return l_temp;
  end replace_string_json;