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 .
