RE: Riddle me this.....

From: SHEEHAN, JEREMY <Jeremy.Sheehan_at_fpl.com>
Date: Thu, 9 Apr 2009 14:56:29 -0400
Message-ID: <8833494F383585499CB855121711D2631391993710_at_JBXEXVS02.fplu.fpl.com>



It works in 9.2.0.8 and with the following query... Any ideas?

select * from pjm_nm_sttl_component

    where sttl_id in to_number(
(select sttl_id_iso from isolink_pjm_sttl_estim_w_iso

     where  sttl_id   =  '131545258'                   
     ) )


Jeremy
 Consider the environment. Please don't print this e-mail unless you really need to.

-----Original Message-----
From: SHEEHAN, JEREMY
Sent: Thursday, April 09, 2009 2:47 PM
To: oracle-l_at_freelists.org
Subject: Riddle me this.....

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. i0zX+n{+i^ Received on Thu Apr 09 2009 - 13:56:29 CDT

Original text of this message