Re: Select Distinct with LOB fields

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 5 Sep 2007 17:05:04 +0200
Message-ID: <46dec5bc$0$241$e4fe514c@news.xs4all.nl>

"Andy Fish" <ajfish_at_blueyonder.co.uk> schreef in bericht news:YizDi.59978$g.7599_at_fe1.news.blueyonder.co.uk...
> 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
>
>

Uhhhh, aren't primary keys always unique? So why distinct? I don't get it...

Shakespeare Received on Wed Sep 05 2007 - 10:05:04 CDT