Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

DBMS_LOB - Compare
-- 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;

Oracle 11g CLOB Compare using DBMS_LOB

Oracle DBMS_LOB - Append CLOB

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: November 01, 2014

  39886