Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 400 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How can I parse below format XML data into tables.

Using GET method with webservice I have stored below XML format response in a CLOB variable. Now i need to parse it into columns and rows of a table. Due to different format of below XML, am not able to store into table. Could you please suggest how to do that.
XML data:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<p:testQueryResponse xsi:schemaLocation="http://hl7gbo.test.abc.com/v401439 testQueryResponse.xsd" xmlns:p1="http://hl7gbo.test.abc.com/v401439" xmlns:xsi="http://www.w3w.orgs/2001/XMLs" xmlns:p="http://hl7gbo.test.abc.com/v401439">
<header>
<id identifierName="MQTIAQUERYID" extension="bunstBrch"/>
<creationTime value="212303244093450.966"/>
<acknowledgement>
<typeCode code="AA"/>
<targetMessage>
<id identifierName="TID" extension="targetmessage"/>
</targetMessage>
<acknowledgementDetail>
<typeCode/>
<code code="200"/>
<text value="Successfully Completed"/>
</acknowledgementDetail>
</acknowledgement>
</header>
<test> -- rows start from here
<testInfo>
<id>
<item identifierName="CCODE" extension="ADP"/> -- CCODE,PCODE &UCODE are column names
<item identifierName="PCODE" extension="112318"/>
<item identifierName="PRIMARYCODE" extension="11dDE="/>
<item identifierName="UCODE" extension="87339048"/>
</id>
<code codeSystemName="RarsraN" codeSystem="ADP" code="12448">
<displayName value="HEV DNA, AN, LEOA"/>
<translation valueSet="UCODE" codeSystem="DBS" code="8700011348"/>
<translation codingRationale="P" valueSet="TESTID" codeSystem="DBS" code="11348RXE="/>
<translation valueSet="TESTID" codeSystem="DBS" code="11348RXE"/>
<translation valueSet="TESTID" codeSystem="DBS" code="XE11348"/>
<translation valueSet="ADC" codeSystemName="TESTNAME" codeSystem="TNM" code="435633"/>
</code>
<handlingCode>
<item valueSet="Yes" code="ORDERABLEBYINDICATOR"/>
<item valueSet="No" code="RINDICATOR"/>
<item valueSet="AVC Referral" code="PERFTYPE"/>
<item valueSet="No" code="CLIENTINDICATOR"/>
<item valueSet="Yes" code="INDFLAG"/>
<item valueSet="No" code="DEFAULTINDICATOR"/>
</handlingCode>
<aliasInfo>
<aliasLIS>
<code codeSystemName="CORPORATE" codeSystem="AVS"/>
<text value="RNA"/>
</aliasLIS>
<aliasLIS>
<code codeSystemName="CORPORATE" codeSystem="AVS"/>
<text value="HEPATIT"/>
</aliasLIS>
</aliasInfo>
</testInfo>
<performer>
<location>
<organization>
<code codeSystem="AVS" code="PO"/>
<name>
<item>
<part value="SJC" type="TITLE"/>
</item>
</name>
<addr>
<item use="H">
<part value="23458 HWY" type="SAL"/>
<part value="JUNA" type="CTY"/>
<part value="ND" type="BTA"/>
<part value="12345-4364" type="ZIP"/>
</item>
</addr>
</organization>
</location>
</performer>
<IInfo>
<code codeSystemName="adsCorporate" codeSystem="UTR" code="863520"/>
</IInfo>
</test>
</p:testQueryResponse>