Re: Riddle me this.....

  • From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
  • To: Jeremy.Sheehan@xxxxxxx
  • Date: Thu, 09 Apr 2009 14:39:46 -0500

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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2009