Re: Hotsos Symposium, Day 3

Hi Jared,

the queries *are* different now, but they *were* identical initially -- Jonathan fixed the typo, based on Mario's feedback. Unfortunately, you cannot perform a flashback query in browsers :-)

cheers,

Lex.

> 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
>

--
http://www.freelists.org/webpage/oracle-l