<PropertyName xmlns="http://ACORD.org/Standards/Life/2">LastName</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">GovtID</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">GovtIDTc</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ResidenceState</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ActivityTypeCode</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ActivityDescription</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">UserCode</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ActivityTypeCode</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ActivityStatus</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">ActivityTypeCode</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">Closed</PropertyName>
<PropertyName xmlns="http://ACORD.org/Standards/Life/2">Closed</PropertyName>
i want to extract these values
LastName
GovtID
GovtIDTc
ResidenceState like this i am using the query here can any body help me on this
For I In (SELECT extract(value(t),'//CriteriaExpression/Criteria/PropertyName','xmlns="http://ACORD.org/Standards/Life/2"').getstringval() pname
FROM TABLE (XMLSEQUENCE (EXTRACT(xml_data_val,'/TXLife/TXLifeRequest/CriteriaExpression','xmlns="http://ACORD.org/Standards/Life/2"'))) t
)
LOOP
DBMS_OUTput.PUT_LINE(i.pname);
END LOOP;
Edited by: mdrake on Nov 26, 2010 7:22 PM