Re: Hotsos Symposium, Day 3

The first 2 queries are different.

The difference is NOT IN vs NOT EXISTS.

The NOT IN subquery causes the query to returns no rows because some of the values returned from the subquery are NULL, and NULLs cause the statement to fail.

Try it.

Jared

On Thu, 10 Mar 2005 18:35:34 +0100, Mario Cariggi <hacedor_at_tiscali.it> wrote:
> Hi Jonathan,
>
> >I'm a bit late in getting this posted, because of various, and
> >mysterious, issues with my wireless networking connection:
> >
> >http://www.oreillynet.com/pub/wlg/6640
>
> Do I miss anything or the first two queries are identical?
> you forget to substitute 'NOT IN' with 'EXISTS' in the
> second one. Your reports from Hotsos are very useful.
>
> Regards.
>
> Mario from Rome, Europe
>
> __________________________________________________________________
> Tiscali Adsl 3 Mega Flat con 3 MESI GRATIS!
> Con Tiscali Adsl 3 Mega Flat navighi con la supervelocita'
> a soli 29.95 euro al mese, senza limiti di tempo. E se attivi
> entro il 15 Marzo, 3 MESI sono GRATIS!
> Scopri come su http://abbonati.tiscali.it/adsl/
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l