6 Replies Latest reply: Jun 17, 2013 2:41 AM by Mark1970 RSS

    How to extract datas from XML file and insert into oracle table

    845914
      Hi all,
      I have a table

      create table employee
      ( emp_id varchar2(10),
      emp_name varchar2(20));

      and

      I have an XML file

      <?xml version="1.0"?>
      <Employee_Details>
      <Employee>
      <emp_id>100</emp_id>
      <emp_name>Steven</emp_name>
      </Employee>
      <Employee>
      <emp_id>101</emp_id>
      <emp_name>Neena</emp_name>
      </Employee>
      <Employee>
      <emp_id>102</emp_id>
      <emp_name>Lex</emp_name>
      </Employee>
      <Employee>
      <emp_id>103</emp_id>
      <emp_name>Alexander</emp_name>
      </Employee>
      </Employee_Details>

      How should i insert the data in xml file into the table using plsql.

      Edited by: user13552077 on Apr 27, 2011 5:24 AM