Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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