System Packages Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Packages
  4. 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> --