Compare two XMLTypes in XML DB [message #362218] |
Mon, 01 December 2008 06:01 |
saras_13
Messages: 1 Registered: December 2008
|
Junior Member |
|
|
HI All,
I want to use the functionality of Oracle XML DB (of Oracle Database 10g Version 2)to store/query/update XML documents by using XMLType data type. I have following questions:
1. I need to compare two XMLType of two rows in a table and copy/override an attribute/element content of a XMLType from another XMLType. Both the XMLTypes are instances of same XML Schema. How can I achieve this?
2. I want to expose the data/content in a XMLType external to the database. Basically, I am looking for a way by which the XMLType can be exposed as relational data without using extractValue() API.
3. What will be the performance of my application, which will query/insert/update the XMLType columns using XML APIs provided by XML DB like updateXML()?
Any help, very much appreciated.
Regards
|
|
|