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: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 7 Sep 2007 12:10:10 +0100
Message-ID: <MPG.214b41da4e682a7398a49e@news.individual.net>


In article <46e01453$0$233$e4fe514c_at_news.xs4all.nl>, Shakespeare says...
> > select foo.pk, foo.data
> > from foo
> > where exists ( select null from bar where foo.pk = bar.fk );
> >
>
> I would not use select null here... It works, but I have seen some
> discussions about null before in this group ;-)
>
>

Can you elaborate on that? Surely it doesn't matter what is selected - it's a case of if the subquery returns 0 rows or not?

-- 
jeremy
Received on Fri Sep 07 2007 - 06:10:10 CDT

Original text of this message

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