PLSQL XML特殊字符转换

2025-04-08 技术教程

---特殊字符转换

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;

声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。