I have an xml document that I imported from a file into a clob column of a table.
I cannot figure out the PL/SQL syntax for how to extract a few of the values (IntOrderID, AbutmentKitID) as shown below.
Can anyone help.
Thank you.
<?xml version="1.0"?>
<DentalContainer version="2016-1">
<Object name="MainObject" type="TDM_Container">
<Object name="OrderList" type="TDM_List_Order">
<List name="Items">
<Object type="TDM_Item_Order">
<Property name="IntOrderID" value="6862677"/>
<Property name="ExtOrderID" value=""/>
</Object>
</List>
</Object>
<Object name="ModelJobList" type="TDM_List_ModelJob">
<List name="Items">
<Object type="TDM_Item_ModelJob">
<Property name="ModelJobID" value="MJD175757DD62646F0B8B873C7B79C7338"/>
<Property name="OrderID" value="6862677"/>
</Object>
</List>
</Object>
<Object name="ToothElementList" type="TDM_List_ToothElement">
<List name="Items">
<Object type="TDM_Item_ToothElement">
<Property name="ToothElementID" value="TE3AD1A9767B40402294B06FA20743F940"/>
<Property name="ModelElementID" value="ME43BE6EC02C344B3E93F3892A39E04BA7"/>
<Property name="AbutmentKitID" value="41980_I574 Kit"/>
<Property name="Anatomical" value="False"/>