RE: Riddle me this.....

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

Sorry! The query works, it just returns no rows.  

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


-----Original Message-----
From: Michael McMullen [mailto:ganstadba@xxxxxxxxxxx] 
Sent: Thursday, April 09, 2009 3:16 PM
To: SHEEHAN, JEREMY; oracle-l@xxxxxxxxxxxxx
Subject: RE: Riddle me this.....

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'                   
     )

Other related posts:

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