RE: Riddle me this.....

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

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Thursday, April 09, 2009 3:12 PM
To: SHEEHAN, JEREMY
Subject: RE: Riddle me this.....

I think it would be helpful if you provided the list with the error number/message you're receiving.

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY Sent: Thursday, April 09, 2009 11:47 AM 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. --
http://www.freelists.org/webpage/oracle-l

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

��i��0���zX���+��n��{�+i�^ Received on Thu Apr 09 2009 - 14:15:35 CDT