I've discovered that on Oracle 10gR2 Express Edition I can't use XMLTABLE but I can/must use XMLSEQUENCE and EXTRACT/EXTRACTVALUE for loading an XML file.
Since it's my first time, I can't understand how to do.
I report a simple example.
I have this XML called myxml.xml
I'd like an example of how using XMLSEQUENCE and EXTRACT/EXTRACTVALUE for loading a node of myxml.xml file stored in /mydirectory/.
I believe it might be something like this:
but I don't know.
My target is how to load an external xml file in a xmltype column of a table and then scanning the column for extract the value to be inserted in the right tables.
This should get you on your way
Re: How to insert the data from XML to a table
It has the parts you need. You can do an INSERT INTO ... SELECT BFILENAME(...) ... to get the data loaded into your table and then run the final SQL statement that Odie_63 shows to load your tables. That or do it all in one step.