Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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> --