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

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

    user9976660
      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.