XMLTYPE
is below:
- <xmlDoc>
- <row>
<transDate>12/Jan/2011</transDate>
<sitecode>50</sitecode>
<wbs1>11</wbs1>
<wbs2>1700</wbs2>
<glAccount>1520D</glAccount>
<cost>153.31560869827</cost>
</row>
- <row>
<transDate>11/Jan/2011</transDate>
<sitecode>50</sitecode>
<wbs1>11</wbs1>
<wbs2>1700</wbs2>
<glAccount>1520D</glAccount>
<cost>21.496070612981</cost>
</row>
.
.
.
.
- <row>
<transDate>06/Jan/2011</transDate>
<sitecode>50</sitecode>
<wbs1>11</wbs1>
<wbs2>1700</wbs2>
<glAccount>1520D</glAccount>
<cost>51.105202899424</cost>
</row>
- <row>
<transDate>02/Jan/2011</transDate>
<sitecode>50</sitecode>
<wbs1>11</wbs1>
<wbs2>1700</wbs2>
<glAccount>1520D</glAccount>
<cost>58.775411861452</cost>
</row>
</row>
<xmlDoc>
It takes approximately 11 minutes to insert all of the 22970 records. Is there something I