Login

[Anniecheng]

these are the two XML files.
XML1.xml
<?xml version="1.0" encoding="UTF-8"?>

<pets>

<pet name="Maximillian" type="pot bellied pig" age="3">
<friend name = "Augustus"/>
<frined name = "Nigel"/>
</pet>


<pet name="Augustus" type="goat" age="2">
<friend name = "Maximillian"/>
</pet>

<pet name="Nigel" type="chipmunk" age="2">
<friend name = "Maximillian"/>
</pet>
<pets>

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

<cat>

<cat name="Chader" type="pot bellied pig" age="3">
<partner name = "Lucky"/>
<partner name = "Nisom"/>
</cat>


<cat name="Yamilia" type="chipmunk" age="2">
<partner name = "Chader"/>
</cat>

<cat name="Suili" type="goat" age="2">
<partner name = "Chader"/>
</cat>
<cat>

how to convert the two XML file onto a new format(userxml),and change the word in the text as blow,
Xml1.xml Xml2.xml Usrxml
pet cat animal
friend partner companion

actually it is a table.

after convert, how to save the userxml table at the oracle database?
thank you .