Shulou(Shulou.com)06/01 Report--

-Special character conversion

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,'','& apos;') 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'ERRORPHY'

End process_xml

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.