Distinct on CLOB
I have a table with one of the column as CLOB,My requirement is as below.
1)Get distinct data to eliminate the duplicate records from the load (Which includes CLOB column too)
2)Need to compare the old data in the table with incoming source data .
Both these cases I need to deal with CLOB objects whihc made my life difficult.
Can some one suggest an appropriate solution,as ,how to handle the scenario as well CLOB objects in these kind of scenarioes.
You could create a hash of the clob with DBMS_CRYPTO.HASH and then distinct based on the hashed values.
Click Here to Expand Forum to Full Width