Re: Select Distinct with LOB fields

Andy Fish wrote:
> Hi,
>
> I want to do a "Select distinct" including a table which has LOB columns and
> I see from the Oracle documentation that this is not possible.
>
> all of my tables have a unqiue primary key which is an integer and is
> included in the select target list. is there any way to tell oracle that it
> only needs to use the PK field to test for uniqueness and doesn't have to
> compare the whole returned row?
>
> my current favourite solution is to post-filter the results in my C# code to
> remove duplicates manually. does anyone have any better solutions than that
> ?
>
> TIA
>
> Andy

I believe you misread the doc. There is nothing wrong with using SELECT DISTINCT on a table with LOBs as long as you don't include the LOB in the columns selected.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org