Hi Team,
I have one requirement as below , any suggestions are highly appreciated.
I have a out file named test.out and the data inside it as below
<Header>
<Tag1>1<tag1>
<Tag2>2<tag2>
<Tag3>3<tag3>
<G_main>
<main>
<customer_number>value1</customer_number>
</main>
<main>
<customer_number>value2</customer_number>
</main>
<main>
<customer_number>value3</customer_number>
</main>
<main>
<customer_number>value4</customer_number>
</main>
<main>
<customer_number>value5</customer_number>
</main>
<main>
<customer_number>value6</customer_number>
</main>
</G_main>
</Header>
I want to read the xml and load into a table as below.
| Tag1 | Tag2 | Tag3 | Customer_number |
| 1 | 2 | 3 | Value1 |
| 1 | 2 | 3 | Value2 |
| 1 | 2 | 3 | Value3 |
| 1 | 2 | 3 | Value4 |
| 1 | 2 | 3 | Value5 |
| 1 | 2 | 3 | Value6 |
Iam using XMLDOM and XML TYPE
but iam strucked in loading the multiple customer details for the same header values.
kindly suggest.
Thanks,
Ash