Mega Code Archive
Categories
/
Oracle PLSQL
/
System Packages
Use dbms_lob compare to compare
SQL> SQL> declare 2 c1 clob := 'chris'; 3 c2 clob := 'sean'; 4 begin 5 dbms_output.put_line(dbms_lob.compare( c1, c2 ) ); 6 end; 7 / -1 PL/SQL procedure successfully completed. SQL> --