Results 1 to 8 of 8

Thread: Load XML data to relational tables

  1. #1
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    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.


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Load XML data to relational tables

    Try to use DBMS_XMLGEN and DBMS_XMLQUERY predefined packages.


  3. #3
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Load XML data to relational tables

    use this link


  4. #4
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    Re: Load XML data to relational tables

    Quote Originally Posted by debasisdas View Post
    Try to use DBMS_XMLGEN and DBMS_XMLQUERY predefined packages.
    Thanks very much! I'll let you know how it goes.


  5. #5
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    Re: Load XML data to relational tables

    Quote Originally Posted by susarlasireesha View Post
    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.


  6. #6
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    Re: Load XML data to relational tables

    Quote Originally Posted by susarlasireesha View Post
    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.


  7. #7
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    Re: Load XML data to relational tables

    Quote Originally Posted by icepack2000 View Post
    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!


  8. #8
    Junior Member
    Join Date
    Mar 2008
    Answers
    7

    Re: Load XML data to relational tables

    Quote Originally Posted by icepack2000 View Post
    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!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact