Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select Distinct with LOB fields

Re: Select Distinct with LOB fields

From: Andy Fish <ajfish_at_blueyonder.co.uk>
Date: Thu, 06 Sep 2007 07:55:51 GMT
Message-ID: <boODi.64262$g.22373@fe1.news.blueyonder.co.uk>


>
> select pk, data from foo where pk in (select fk from bar);
>

thanks for this hint (and to cleveridea) for the other one.

any idea if either of these have significant performance deteriment compared to the basic select ? Received on Thu Sep 06 2007 - 02:55:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US