Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xpath syntax for extracting property value

Uncle BuckJun 21 2016 — edited Jun 27 2016

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"/>

This post has been answered by odie_63 on Jun 24 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2016
Added on Jun 21 2016
6 comments
3,034 views