Re: PL/SQL and Cursors

On Wed, 03 Sep 1997 17:40:58 -0400, "Bryan J. Gentile" <bgentile_at_bdsinc.com> wrote:

>Is it possible with PL/SQL to nest a cursor within another cursor? If
>so, how can I do this, some sample code would be very beneficial.
>Thanks in advance. If possbile, can you email me a response as well as
>replying to this posted message?

declare

  cursor c1 is select * from dept;
  cursor c2 (v_deptno) is select * from emp where deptno = v_deptno;

begin

  for r1 in c1 loop
    for r2 in c2 (r1.deptno) loop   

    <do your thang!>

    end loop;
  end loop;

end;

I didn't have the Oracle book on my lap, so syntax errors may occur

;-)
-------------------------------------------------------------------------------
--- Martin Jesterhoudt                      
--- martinj(replace this by @)worldonline.nl
-------------------------------------------------------------------------------