5 Replies Latest reply on Sep 6, 2012 6:21 AM by AlexAnd

    Compare XMLType column values in two different rows using XMLDiff in 11gR2

      I have a database table with an XMLType row and I need a way to compare the XML data against one another. I assume I could use a function and return a XMLDIFF based output to the caller but the logic of the function is a bit fuzzy. Would be nice to format the output finally into a table format.

      I looked over http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions241.htm#SQLRF20025 and output into a table format like discussed in Re: How to find the compare and identify between xmldocs .

      Examples I have run across don't explain the best and most performing way to compare the XML that is in the XMLType column.

      Any assistance would be appreciated.