Riddle me this.....

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

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.

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

Received on Thu Apr 09 2009 - 13:47:28 CDT