Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

How to get one specified tag value from xml file and insert into table

User_S9M3BMay 30 2018 — edited Jun 4 2018

Hi All ,

I have a xml file in the Unix server and the file get changed daily . I have to catch one tag value  in the xml file and store it in the table .

And the sample.xml file looks like

<ns:Data>

/   <Request>
<CreatedDateTime>2018-05-11</CreatedDateTime>
<Person>
<ID>XX11</ID>

<Name>

<FName>Rama</FName>
</Name>
<Gender>
<GenderCode>Male</GenderCode>

</Gender>

</Person>

   </Request>

   <Request>

  <CreatedDateTime>2018-05-11</CreatedDateTime>

<Person>
<ID>YY11</ID>

<Name>

<FName>Sita</FName>

</Name>

<Gender>

<GenderCode>Female</GenderCode>

</Gender>

</Person>

</Request>

    </ns:Data>

       Here I have to read the value of tag <ID> .

       Thanks

       Sai

Message was edited by: 863516
This post has been answered by mNem on Jun 4 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2018
Added on May 30 2018
#pl-sql-xml-programming, #xml
10 comments
7,077 views