XML Database (MOSC)

MOSC Banner

Processing a complex XML file in oracle

edited Jan 14, 2010 3:42AM in XML Database (MOSC) 2 commentsAnswered
 Hi,

     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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center