Home » Developer & Programmer » JDeveloper, Java & XML » Compare two XMLTypes in XML DB (Oracle 10g release 2)
Compare two XMLTypes in XML DB [message #362218] Mon, 01 December 2008 06:01
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.


Previous Topic: xml parsing in pl/sql
Next Topic: Problem Generating Web Service Proxy (WSDL/XSD) , WCF service
Goto Forum:

Current Time: Tue Feb 27 04:36:20 CST 2024