RE: Riddle me this.....

From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: <Jeremy.Sheehan@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 9 Apr 2009 15:15:36 -0400

What "does not work" mean? No records returned, more,less, ora- error
What's the datatype? If there's implicit conversion going on change to
explicit. I've had so many hassles because of implicit conversion
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of SHEEHAN, JEREMY
Sent: Thursday, April 09, 2009 2:47 PM
To: oracle-l@xxxxxxxxxxxxx
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'                   
     )



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

References:
- INSERT..VALUES rows processed > executions
  - From: Charlotte Hammond
- Riddle me this.....
  - From: SHEEHAN, JEREMY

RE: Riddle me this.....

Other related posts: