1 Reply Latest reply on Jun 13, 2013 3:28 PM by Jason_(A_Non)

    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!