This discussion is archived
2 Replies Latest reply: Feb 14, 2013 1:39 AM by 990303 RSS

XML data Into Table with Columns

990303 Newbie
Currently Being Moderated
Hi all,

I have a large XML file which i have loaded into my Oracle 10g DB in windows XP..I have no idea of the nodes..and the count of each nodes in xml...is it possible to create a table directly with xml's node names as column?? and also i have to generate xsd file with this current xml doc...

Legend

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