What would be the fastest, easy, and quickest way to import an xml data to a database table in Oracle 10g database? What tool should I use (if possible free)?
The XML will look like this:
<?xml version="1.0" encoding="utf-8"?>
<badges>
<row Id="82946" UserId="3718" Name="Teacher" Date="2008-09-15T08:55:03.923" />
<row Id="82947" UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82948" UserId="3372" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82949" UserId="3893" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82950" UserId="4591" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82951" UserId="5196" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82952" UserId="2635" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82953" UserId="1113" Name="Teacher" Date="2008-09-15T08:55:03.957" />
<row Id="82954" UserId="4182" Name="Teacher" Date="2008-09-15T08:55:03.957" />
</badges>
Best Answer
What are you importing this file into?
See this question on stackoverflow: Oracle: loading a large xml file?
You can use SQL*Plus with some PL/SQL to import XML into your DB.