How can I Compare two xml documents?

Posted on 16th Feb 2014 07:03 pm by admin

Hi all,

I am doing a POC for my project and I am using XE database 10g version.

I want to make a comparison between two xml document stored in a column of type xmltype in a relational table.

How can I do a comparison between them? Here between two data in rowset column.

SQL> desc emp_xml
Name Null? Type
--------
ROWSET XMLTYPE
EMP_XML_AGN NUMBER

Please help me in this regard.

Thanks

Your Answer:

Login to answer

Other forums

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the

Why does my crawler script suddenly end with no error?
Hi.

I have written a web crawler script. It will visit a large number of URL's with cURL.

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

PHP submit form script causing blank page
Im trying to submit a form using this script, however nothing shows up on the page, does anyone know