Two Laptop Bag*
The moose likes Oracle/OAS and the fly likes How to export data from XML file to a table ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to export data from XML file to a table ?" Watch "How to export data from XML file to a table ?" New topic
Author

How to export data from XML file to a table ?

majid nakit
Ranch Hand

Joined: Jun 26, 2001
Posts: 164
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

Joined: Oct 06, 2007
Posts: 338
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to export data from XML file to a table ?