Re: Riddle me this.....
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 9 Apr 2009 14:16:59 -0500 (CDT)
Message-ID: <5285e66a129ff0ae943bde22186fc340.squirrel_at_society.servebeer.com>
> select * from pjm_nm_sttl_component
> where sttl_id = '130637378'
>
> We're running 10.2.0.4 on AIX 5.3.7
>
> Any ideas?
>
Date: Thu, 9 Apr 2009 14:16:59 -0500 (CDT)
Message-ID: <5285e66a129ff0ae943bde22186fc340.squirrel_at_society.servebeer.com>
> 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-lReceived on Thu Apr 09 2009 - 14:16:59 CDT