Oracle 9i Clob Resolved
Working with CLOBs has been very difficult. The task was to extract all unique messages that were in LDR2 and not in LDR into a UNIQUE table. Set commands such as,MINUS, INTERSECT, =, etc, won’t work with CLOBs datatypes. But using dbms_lob.getlength, dbms_lob.Compare, and dbms_Utility.Get_hash_value. This sql OUTER-JOIN finally worked: insert into seebeyond.RAD_MESSAGES_UNIQUE (SELECT seebeyond.RAD_MESSAGES_LDR2.MESSAGES, […]