select -> select

From: Fredrik Åkesson <fredrik.akesson_at_NOSPAM.eng.ericsson.se>
Date: Wed, 12 Aug 1998 15:36:47 +0200
Message-ID: <35D19A6F.3E672714@NOSPAM.eng.ericsson.se>

I need to run a select statement for_each_found_row in another select statement, i.e.:
(note: the example is in interbase sql, but I need the PL/SQL solution)

select ...
into ...
from ...

do
  begin

     select ...
     into ...
     from ...
     do
       suspend
     end

  end

Is a cursor the best way to do this?

Thanks
Fredrik Received on Wed Aug 12 1998 - 08:36:47 CDT