---特殊字符转换
function process_xml(old_xml in varchar2) return varchar2 as
new_xml varchar2(1000);
begin
select replace(old_xml, '<', '<') into new_xml from dual;
select replace(new_xml, '>', '>') into new_xml from dual;
select replace(new_xml, '&', '&') into new_xml from dual;
select replace(new_xml, '''', ''') into new_xml from dual;
select replace(new_xml, '"', '"') into new_xml from dual;
SELECT regexp_replace(new_xml, '^(\W)*|(\W)*$', '')
INTO new_xml
FROM dual;
return new_xml;
exception
when others then
return 'ERROR!';
end process_xml;
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。