<div>
Would it be better if I convert the two CLOB's into an Integer Value and compare the values?<br />
<br />
Thanks,<br />
Troy
</div>


Would it be better if I convert the two CLOB's into an Integer Value and compare the values?

Thanks,
Troy

<div>
 &nbsp;1 &nbsp;SELECT A.COL1<br />
&nbsp; 2 &nbsp;FROM CLOB1 A, CLOB2 B<br />
&nbsp; 3* WHERE DBMS_LOB.COMPARE(A.COL1,B.<wbr />COL1)= 0<br />
SQL&gt; /<br />
<br />
COL1<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----<br />
ABCDEFGHIJK<br />
LMNOPQRST
</div>


 1  SELECT A.COL1
  2  FROM CLOB1 A, CLOB2 B
  3* WHERE DBMS_LOB.COMPARE(A.COL1,B.COL1)= 0
SQL> /

COL1
--------------------------------------------------------------------------------
ABCDEFGHIJK
LMNOPQRST

<div>
<div class="content wysiwyg-content">
<br />
How do I compare two strings/CLOBs in Oracle 9.2?<br />
I have a new CLOB value and I need to compare it with another CLOB value in a table. &nbsp;If the new and old values are different, I need to update the table. &nbsp;Otherwise, I move on to the next record.<br />
<br />
Is there a PL/SQL function that can compare two CLOBs with each other?<br />
<br />
Thanks,<br />
Troy
</div>
</div>



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?

Thanks,
Troy

How do I compare two strings/CLOB in Oracle 9.2?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.