Riddle me this.....

  • From: "SHEEHAN, JEREMY" <Jeremy.Sheehan@xxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Apr 2009 14:47:28 -0400

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.
--
//www.freelists.org/webpage/oracle-l

Other related posts:

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