Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up Unanswered: Loading data from XML file into table using SQL Loader

    Hi

    I have a table and the data for that table is present in a XML file. The format of the XML file is like this
    Code:
    <rows>
    <row>
    <col1>Col1 data</col1>
    <col2>Col2 data</col2>
    .
    .
    <row>
    
    <row>
    <col1>Col1 data</col1>
    <col2>Col2 data</col2>
    .
    .
    <row>
    
    .
    .
    </rows>
    I want to load this data into the Oracle database using SQL Loader.

    Can any offer me some suggestions or pointers?

    Thanks for your time and help.
    Sudar

    --
    My Blog

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Incapable or unwilling to use Google?
    GOOGLE is your friend but only is you actually use it.
    Results 1 - 10 of about 4,030,000 for oracle load xml file data.
    Are you claiming that NONE of the 4 MILLION+ pages gives you a sufficient clue as to how you can load XML data into Oracle?

    such as
    http://download-east.oracle.com/docs...9/xdb25loa.htm
    Last edited by anacedent; 04-10-07 at 18:13.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    The XML developers guide has some nice examples of doing this, take a look at them here.

  4. #4
    Join Date
    Sep 2009
    Posts
    1

    Angry Just Had To Be A Prick, Right?

    Quote Originally Posted by anacedent
    Incapable or unwilling to use Google?
    GOOGLE is your friend but only is you actually use it.
    Results 1 - 10 of about 4,030,000 for oracle load xml file data.
    Are you claiming that NONE of the 4 MILLION+ pages gives you a sufficient clue as to how you can load XML data into Oracle?

    such as
    Loading XML Data Using SQL*Loader
    Ever occur to you that maybe he had done a Google search and simply needed further help understanding the info he found? Never occurred to you, Mr. Perfect, that maybe he read all those docs and was still in need of assistance?

    If it is 'inappropriate' to come to an open forum on DB's and ask a DB question...then what exactly is the purpose of the forum? To sit around and wait for some poor slob to come in looking for an answer to a pressing or confusing issue, so you can exert your superiority of knowledge over him/her and get a good laugh?

    Must be nice to be such a brainiac that you never, ever need to ask for additional help.

    Pompous A..hole.

  5. #5
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    I'm sure Ana just missed her meds last night. But I just answered this question like two days ago on this forum.

    http://www.dbforums.com/oracle/16474...nto-table.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •