there are two xml file, xml1.xml and xml2.xml, how to convert them onto a new format(userxml)?
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>
after convert the two xml file, how to save the new format userxml into oracle database?
