RE: Riddle me this.....
From: SHEEHAN, JEREMY <Jeremy.Sheehan_at_fpl.com>
Date: Thu, 9 Apr 2009 15:22:37 -0400
Message-ID: <8833494F383585499CB855121711D263139199374A_at_JBXEXVS02.fplu.fpl.com>
it does return a single row.
Date: Thu, 9 Apr 2009 15:22:37 -0400
Message-ID: <8833494F383585499CB855121711D263139199374A_at_JBXEXVS02.fplu.fpl.com>
it does return a single row.
Jeremy
Consider the environment. Please don't print this e-mail unless you really need to.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse
Sent: Thursday, April 09, 2009 3:17 PM
To: oracle-l_at_freelists.org
Subject: Re: Riddle me this.....
> select * from pjm_nm_sttl_component
> where sttl_id = '130637378'
>
> We're running 10.2.0.4 on AIX 5.3.7
>
> Any ideas?
>
Does the subquery returns one and only one row? I believe it must for your equality to work (without trying it myself!)...
Rich
--
http://www.freelists.org/webpage/oracle-l
i0zX+ n{+i^ Received on Thu Apr 09 2009 - 14:22:37 CDT