Re: Riddle me this.....

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Apr 2009 14:16:59 -0500 (CDT)

> 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


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

Other related posts:

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