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));


I have an XML file

<?xml version="1.0"?>

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

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


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