Oracle DB: Delete or Replace XML
Here are 2 examples of how to delete or replace xml part: Supposing that we have a variable l_xmltype of type XMLTYPE containing an XML: --delete XML;select xmltype(deletexml(xmltype('<s:a xmlns:s="qw"><s:b><return></return></s:b></s:a>'),…