I have table with Blob column. In the blog column I have XML data (see below).
I wanted to parse xml and get the value of note '<GetTest>'. How do I achieve that?
Sample Table:
create table SAMPLE_XML_TABLE
(
ID NUMBER not null,
XMLSTRING BLOB,
);
<?xml version="1.0" standalone="no"?>
<FromResponse xmlns="http://www.somewebsite.com/FromResponse">
<Code>0000</Code>
<Seller>
<SellerServer>
<Version>01</Version>
<Sample>
<GetTest>I wanted to get this Text</GetTest>
</Sample>
</SellerServer>
</Seller>
</FromResponse>