1 Reply Latest reply: Jun 13, 2013 10:28 AM by Jason_(A_Non) RSS

    Is this a good way for loading and handling an xml file?

    Mark1970

      I'm new to xml files, but it seems to me that a good way to handle them may be this:

      - create an xmltype table with a unique xmltype column

      - load the xml file in the xmltype column of the table

      - writing a procedure for scanning the whole column of the table by using the extractvalue built-in function for inserting the different nodes of the xml file (just loaded) in the final tables (to link correctly the father and son tags with foreign keys)

       

      Does it seem to you a good way to load the nodes of a xml file in a relation database?

       

      Thanks!