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

Thread: Distinct Clobs

  1. #1
    Join Date
    Oct 2007

    Distinct Clobs

    So i founjd a thread that sounded liek it solved my problem, but could not get resolve.

    liek the thread starter, I wish to retrieve distinct values that are CLOB fields.

    I have only two columns i am concerned with, one is session_type and request_clob.

    i would like to see the first 1000 distinct requests that belong to the particular session type.

    I have;
    select * from ebr_r.session_cr where
    (session_type='address-cleanse' or 
    session_type='ADDRESS_CLEANSE' )and
    created_datetime >= TO_DATE('2007-10-01 09:00', 'YYYY-MM-DD HH:MI')

    which was explained to be wrong, does not work.

    How would this work. I did not understand the use of all the extraneous fields in the example given.

    Thanks for the help!
    Last edited by masterkeedu; 10-23-2007 at 08:37 AM.

  2. #2
    Join Date
    Oct 2007


    Well though I am still curious, I ahve solved my issue wih an lternate route.

    I wrote a small yet robust Java appt o handle this for me. The app retirves mathcing records based on 5 criteria.

    All matching recotrdas are then screened for duplicate values within the clob field. I determin duplicates using 1 to 8 values found within the clobs.

    since the clobs are all xml i can retive key fields like session id to detemin if they are dupes or not.

    at the end, all non-duplicate records have their xml printed to file.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.