hi do you mean something like this? for i in (select * from dept) loop for x in (select * from emp where deptno = i.deptno) loop ...... end loop; end loop; On 4/18/06, Bob Robert <mssql_2002@xxxxxxxxx> wrote: > > Gurus, > > Is it posssible to write cursor in side of another cursor? > > Thanks, > Bob > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- > //www.freelists.org/webpage/oracle-l > > >