Hi ALL,
I want to know the parsing of XML.
The description of Problem:
One table is there ABC.
In ABC table two columns are there named A and B where A is varchar and B is clob.
IN B column the data is in XML format. The structure of XML is
<inv1:structureFormats>
<cus:sfType>ADDRESS</cus:sfType>
<cus:name>ADDR_FOR_INDIA</cus:name>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>Address Line1</cus:name>
<cus:componentType>N</cus:componentType>
<cus:value>IT 3, Ground Floor, Zone 1&2, Incubation, BlueRidge, New Cognizant, Rajiv Gandhi Infotech Park</cus:value>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>Address Line2</cus:name>
<cus:componentType>N</cus:componentType>
<cus:value>Phase 1, Hinjewadi</cus:value>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>Address Line3</cus:name>
<cus:componentType>N</cus:componentType>
<cus:value/>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>Landmark</cus:name>
<cus:componentType>N</cus:componentType>
<cus:value/>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>Country</cus:name>
<cus:componentType>G</cus:componentType>
<cus:value>India</cus:value>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>State</cus:name>
<cus:componentType>G</cus:componentType>
<cus:value>Maharashtra</cus:value>
</cus:structureFormatComponents>
<cus:structureFormatComponents>
<cus:id>0</cus:id>
<cus:name>City</cus:name>
<cus:componentType>G</cus:componentType>
<cus:value>Mumbai</cus:value>
</cus:structureFormatComponents>
</inv1:structureFormats>
THis is data of column A value 1 and column A has another values also for which the structure of XML is same but the values are different.
How will i geet the data suppose for value 1 of the city is Mumbai
bue for value 2 the city may b hyderabad.
