Use dbms_lob.compare to compare clob type value with offset
SQL>
SQL> declare
2 c1 clob := 'chris';
3 c2 clob := 'sean';
4 begin
5 dbms_output.put_line(dbms_lob.compare( c1, c2, 1, 5, 1 ) );
6 end;
7 /
0
PL/SQL procedure successfully completed.
SQL> --
Related examples in the same category