• 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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!