How to get distinct on CLOB
696798Nov 24 2009 — edited Nov 25 2009Hi,
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 which 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.
Thanks in advance,
Rajesh.