Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
I have following problem. External firm sending me a XML file with some fields for example: <price>5000$</price>;
In my DB i have table with this column and i have to make a script in PL/SQL which is finding in my DB fields and compare with fields written in this XML file.
XMLDiff gets slower as the size of documents grows.
If you know which elements/attributes to check, I think it's better to load the file in an XMLType table (may be temporary) and use XMLTable to parse it relationally.
You could even directly join the XMLTable dataset to your base table in order to perform the comparisons in plain SQL.