-- Compare two CLOB data using DBMS_LOB

SELECT
 DBMS_LOB.compare(RPAD('A',30000,10),RPAD('A',30000,10)) lob_compare1, 
 DBMS_LOB.compare(RPAD('A',30000,10),RPAD('B',30000,10)) lob_compare2,
 DBMS_LOB.compare(RPAD('B',30000,10),RPAD('A',30000,10)) lob_compare3
FROM DUAL;