Inserting XML data into a table.
<?xml version="1.0" encoding="UTF-8" ?>
<MyMsg xmlns="">
<Item name="John" surname="Chisholm" age="56" />
more items here
</MyMsg>
How can I insert this data into a normal Oracle table that has the three columns name, surname and age ??
Using DBMS_XMLSTORE???
If I modify the xml format to the classic <name>John</name> form, I can do it, but the data does not come in that form. It comes as a set of attributes. I have no control over that so must find a way to do the insert using the data as provided.