This discussion is archived
6 Replies Latest reply: Jun 17, 2013 12:41 AM by Mark1970 RSS

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

845914 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points