XML Database (MOSC)

MOSC Banner

how to load xml in a relational table using xmldb

edited Oct 30, 2012 4:21PM in XML Database (MOSC) 2 commentsAnswered

hi ,

i'm a newbie w/ xmldb . have read that xmldb could parse the file and load it to relational table. how do i do it?

it need to be loaded in 3 tables (invoice, invoice_det (item,qty,price), pymt_det).

below is the sample xmlfile..

  <?xml version="1.0" encoding="UTF-8" ?>

- <invoices type="array">

- <invoice>

  <amount>200.0</amount>

  <amount_with_tax>200.0</amount_with_tax>

  <discount_text nil="true" />

  <id>21</id>

  <invoice_no>1</invoice_no>

  <layaway_status />

  <quantity>1.0</quantity>

  <reference>1-1</reference>

  <remark nil="true" />

  <salesman_id>4</salesman_id>

  <status>S</status>

  <tax>0.0</tax>

  <tax_inclusive nil="true" />

  <user_id>4</user_id>

  <voided_reason nil="true" />

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