Thread: Load XML data to relational tables

I want to load data from XML schema into my relational tables. Please suggest how to do this - do I use datapump, SQL*Loader, and how to get started.
Thanks for any suggestions.

Try to use DBMS_XMLGEN and DBMS_XMLQUERY predefined packages.

use this link

Originally Posted by debasisdas

Try to use DBMS_XMLGEN and DBMS_XMLQUERY predefined packages.

Thanks very much! I'll let you know how it goes.

Originally Posted by susarlasireesha

use this link

Thanks very much! I'm using ORacle 10g, I'll look at similar links for Oracle 10g and let you know how it goes.

Originally Posted by susarlasireesha

use this link

Hi,
I reviewed the link and have a problem in that these tools seem to want to put the data into an XML type field. I just want to separate out the nodes in the XML document and put the nodes in to fields in a set of tables. For example let's say I'm getting an XML document with a list of country codes and phone numbers for each person as well as the source of the document, and want to put each of these items into a field in a table.
I'm starting to think I could do this with just SQL Loader or the data pump (I'm using Oracle 10g).
Thanks again for any ideas.

Originally Posted by icepack2000

Thanks very much! I'm using ORacle 10g, I'll look at similar links for Oracle 10g and let you know how it goes.

Hello!
I'm still having problems. Can you point me to examples of how to convert a nested, hierarchical xml document into multiple tables?
Thanks very much!

Originally Posted by icepack2000

Thanks very much! I'll let you know how it goes.

Hello!
I'm still having problems. Can you point me to examples of how to convert a nested, hierarchical xml document into multiple Oracle 10g tables?
Thanks very much!