By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
EXTRACTVALUE(XMLTYPE('<?XMLVERSION="1.0"ENCODING="UTF-8"?><SOAP:ENVELOPEXMLNS:XSI="HTTP://WWW.W3.ORG/2001/XMLSCHEMA-INSTANCE"XMLNS:SOAPENC="HTTP://SCHEMAS.XMLSOAP.ORG/SOAP/ENCODING/"XMLNS:XSD="HTTP://WWW.W3.ORG/2001/XMLSCHEMA"SOAP:ENCODINGSTYLE="HTTP: |
---|
11.11.11.11:2222 |
XMLQUERY('DECLAREDEFAULTELEMENTNAMESPACE"URN:USR1";DECLARENAMESPACESOAP="HTTP://SCHEMAS.XMLSOAP.ORG/SOAP/ENVELOPE/";/SOAP:ENVELOPE/SOAP:BODY/GETADDRESSFORIPRESPONSE/P-ADDRESS/TEXT()'PASSINGXMLTYPE('<?XMLVERSION="1.0"ENCODING="UTF-8"?><SOAP:ENVELOPEXML |
---|
11.11.11.11:2222 |