How do you load data from XML file to a ORACLE table?

Correct Answer: You need to first create a table in oracle that matches with the fields of the XML data So to get the XMl into the table, you can create a generic procedure that moves an XML document into a table by converting the elements to Oracle Canonical format Oracle Canonical format is as follows: ROW is used for the table names ROWSET is used for the XML document You can get the XML into the canonical form using XSL: < /ROW> To transform the XML document into the canonical form, you can write a procedure Make sure you include the line below in your procedure code: v_rows := DBMS_XMLStoreinsertXML( v_context, XMLTypetransform(p_xml_in, p_xsl_in)); The only remaining step is calling your procedure: DECLARE v_xml XMLType := XMLType( YOUR XML Document ); v_xsl XMLType := XMLType( YOUR XSL Document ); BEGIN procedure_name(v_xml, v_xsl, 'table_name'); END;