Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to export data from XML file to a table ?  RSS feed

 
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!