How do I compare two strings/CLOBs in Oracle 9.2?
I have a new CLOB value and I need to compare it with another CLOB value in a table. If the new and old values are different, I need to update the table. Otherwise, I move on to the next record.
Is there a PL/SQL function that can compare two CLOBs with each other?