Hi,

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.