XML Database (MOSC)

MOSC Banner

XMLTYPE

edited Sep 26, 2011 7:02AM in XML Database (MOSC) 4 commentsAnswered
I have an xml document that I have imported that is 22970 rows (records) in length.  An example of my xmlDoc.xml
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

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