Pra Sys
asked on
Extract a substring from xml column from SQL query resultset
I have a table MYTABLE and column MYXML in Oracle 12 database. The column MYXML contains strings like below with varied lengths -
I want to extract just PQ from this column values using SQL query. How do I do that? I should be able to search using Name tag if possible and extracts its value.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:NodeData xmlns:ns2="http://abcd.org/xyz/schema/">
<Head msgId="ACVF63980FGQW56123" orgId="12345" ts="2017-04-13T18:37:27+05:30" ver="1.0"/>
<Info>
<Identity id="45298" verifiedName="MFROMLA" type="TECH"/>
<Rating name="HIGH"/>
</Info>
<Node Name="PQ" Desc="PreQualified" NodeID="2387ajdh231dqhhg21098"/>
</ns2:NodeData>
I want to extract just PQ from this column values using SQL query. How do I do that? I should be able to search using Name tag if possible and extracts its value.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER