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.
Printable View
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 [URL="http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm"]link[/URL]
[QUOTE=debasisdas;28906]Try to use DBMS_XMLGEN and DBMS_XMLQUERY predefined packages.[/QUOTE]
Thanks very much! I'll let you know how it goes.
[QUOTE=susarlasireesha;28910]use this [URL="http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm"]link[/URL][/QUOTE]
Thanks very much! I'm using ORacle 10g, I'll look at similar links for Oracle 10g and let you know how it goes.
[QUOTE=susarlasireesha;28910]use this [URL="http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm"]link[/URL][/QUOTE]
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.
[QUOTE=icepack2000;28917]Thanks very much! I'm using ORacle 10g, I'll look at similar links for Oracle 10g and let you know how it goes.[/QUOTE]
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!
[QUOTE=icepack2000;28916]Thanks very much! I'll let you know how it goes.[/QUOTE]
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!