Hi all,
My need is to compare two blob values using sql or plsql.
Short version: is there any general way to check if two blob values are equal or not?
Longer version: any idea how to compare text from blob value (what was changed after last check) -- assuming it is html page stored as blob?
I realise it is rather tricky as it can be really huge (441936 characters in my case).
Some more information: a bunch of html pages are saved into database table as blob values on regular basis and my need is to (1) say if there are any changes and then (2) to say what exactly changes were made. I suppose, (1) should not be too difficult, though (2) is something for more experienced audience.
Thanks ahead for your attention and for any hint.