DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009

    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.

  2. #2
    Join Date
    Apr 2006
    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