Distinct on CLOB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Distinct on CLOB

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Distinct on CLOB

    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.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You could create a hash of the clob with DBMS_CRYPTO.HASH and then distinct based on the hashed values.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width