This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to export data from XML file to a table ?

 
majid nakit
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am a newbie to Oracle,
Is there any way in oracle on How to export data from XML file to a table ?

or
can I find a java program that does this ?

Thanks, your help is appreciated.
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle 9.2+ databases support XML and you can use XSU: http://www.xml.com/pub/a/2001/06/20/databases.html#oracle

You will have to transform your data types.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic