how to load xml in a relational table using xmldb
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" />