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;
Code:
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!