Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Distinct with LOB fields
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?
-- jeremyReceived on Fri Sep 07 2007 - 06:10:10 CDT