Processing a complex XML file in oracle
I need to process a complex XML file in oracle. Following is description of the XML file. The tags like Match, Outright can loop 100 times. The tags like Sport, Tournament can loop 10 times. How can I process the XML file without editing the XML file?
<BetradarBetData>
<Timestamp/>
<Sports>
<Sport>
<Category>
<Outright>
Fixture data,
odds,
results,
comments
</Outright>
<Tournament>
<Match>
fixture data,
odds,
results,
comments,
BetFairIDs,
TVChannelInfo,
Goals,
Cards
</Match>
</Tournament>
</Category>
</Sport>
</Sports>
</BetradarBetData>
Your help is highly appreciated.
Thanks,
Arun