Re: Riddle me this.....

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Thu, 09 Apr 2009 14:39:46 -0500
Message-ID: <49DE4F02.6030504_at_ardentperf.com>

Can you "explain plan" on both? Curious if it's doing a transformation, might give something to search for in metalink...

SHEEHAN, JEREMY wrote:
> Ok. Here's an interesting question that some developers threw at me. I don't see anything wrong with the statement but it just does not work....
>
>
> This statement does not work.....
>
> select * from pjm_nm_sttl_component
> where sttl_id in -- this statement has the 'in'
> (select sttl_id_iso from isolink_pjm_sttl_estim_w_iso
> where sttl_id = '131545258'
> )
>
> but this one does:
>
> select * from pjm_nm_sttl_component
> where sttl_id = -- this statement has the '='
> (select sttl_id_iso from isolink_pjm_sttl_estim_w_iso
> where sttl_id = '131545258'
> )
>
>
> The subquery works. I can even run the 4 statements. It pulls back the same data as the second statement above.
>
> select * from pjm_nm_sttl_component
> where sttl_id in (130637378)
>
> select * from pjm_nm_sttl_component
> where sttl_id in ('130637378')
>
> select * from pjm_nm_sttl_component
> where sttl_id = 130637378
>
> select * from pjm_nm_sttl_component
> where sttl_id = '130637378'
>
> We're running 10.2.0.4 on AIX 5.3.7
>
> Any ideas?
>
> Jeremy
> Consider the environment. Please don't print this e-mail unless you really need to.

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com

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

Received on Thu Apr 09 2009 - 14:39:46 CDT